Formula

[NCD]

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?

[Suvrutt_Gurjar]

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

[NCD]

thank you!

is there a way I can use editable if its blank or something?

[Suvrutt_Gurjar]

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.

[NCD]

Editableif was a no-go since I have my expression in App Formula 😞

[Suvrutt_Gurjar]

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.

[NCD]

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]).

[Suvrutt_Gurjar · Accepted solution]

 Excellent.

Your requirement  in latest post translates to the following expression.

IF(ISBLANK([Size]),[TotalAmount], CEILING([Size]*[Length]))

https://help.appsheet.com/en/articles/2355953-if

[NCD]

Thank you, I was able to do it and learn from you!