Expiration date! Hello! I used lookup expre...

data
(ramerol iridas) #1

Expiration date!

Hello!

I used lookup expression for a column A, Table X. Now, when i enter the value in Column B, the column A is filling automatically. I need to do this: if i enter the value in column A–>prefill column B, but if there is no value for column B to prefill with, just let me to add something in there manually. Is that possible?

Thank you, and i’m sorry for my bad english.I hope i made my self clear enough.

this is a picture for better understanding what i whant to accomplish

(Dinh Nguyen Nguyen) #2

@ramerol_iridas Are you using an app formula to pre-fill column B? If so, you may want to try using an initial value instead. App formulas cannot be overridden and thus won’t allow the app user to modify column B if the output of the formula is blank. Initial value on the other hand will allow the app users to modify the value. More information about the difference between initial values and app formulas can be found here:

help.appsheet.com - App Formulas and Initial Values App Formulas and Initial Values help.appsheet.com