Hi community =)
I’m trying to make a simple app for member registration and facing a problem with data validation. desperately need help.
I need an formula/expression that sets limit of digits can be inputted in a cell based on the value of other column.
say i have 2 columns, BANK and ACCOUNT NUMBER
i need to limit digits in ACCOUNT NUMBER to 10 if value in BANK is CENTRAL BANK, and limit 15 digits in ACCOUNT NUMBER if value in BANK is LOCAL BANK.
Any help is much appreciated