Is there any way I can get like a in between function of Formula and Initial Value?
What I mean by this is I have a column named Required Amount,
which is driven by a formula CEILING([Size]*[Length]).
But sometimes I would like to leave the Size column blank and type in the Required Amount.
Formula won't allow this and initial value does.
But initial value won't change the number when updated.
what can I do if I want both options?
Solved! Go to Solution.
Excellent.
Your requirement in latest post translates to the following expression.
IF(ISBLANK([Size]),[TotalAmount], CEILING([Size]*[Length]))
May or may not satisfy your requirement depending on when you wish the [Size] column to change and make impact on the other computed column[ Required Amount].
But you could take a look at enabling "reset on edit" feature for initial values.
https://help.appsheet.com/en/articles/961223-column-constraints
thank you!
is there a way I can use editable if its blank or something?
You may wish to try and experiment a bit with that as well as suggested option. Please do approach community with you test results, if the intended functionality is still not achieved.
Editableif was a no-go since I have my expression in App Formula ๐
Correct, that is why requested you to try. You also were trying with initial value. In essence , based on suggestion, you may wish to experiment a bit on possible combinations and you may get a result. You could always approach the community in case still it does not get the desired result.
okay I think I know what I want to say in my expression but don't know how to ๐
In my App Formula I want to say,
IF(ISBLANK([Size],[TotalAmount]))
But if it's not blank I want
CEILING([Size]*[Length]).
Excellent.
Your requirement in latest post translates to the following expression.
IF(ISBLANK([Size]),[TotalAmount], CEILING([Size]*[Length]))
Thank you, I was able to do it and learn from you!
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |