Forum Discussion
Adding text when formula calculates blank
I have the below formula that is calculating the last blank value and pulling it into this new table. My question is it easily possible to add another part of this formula to insert the phrase "Not submitted" if the formula is pulling a blank value.
Hi,
before your formula place If( your whole formula=blank(), "Not submitted", yourfromula)
or to make things cleaner use variable:
Completed=
var vCompleted= your formula
If( vCompleted=blank(), "Not submitted", vCompleted)
3 Replies
- olgad
Resident Rockstar
Hi,
before your formula place If( your whole formula=blank(), "Not submitted", yourfromula)
or to make things cleaner use variable:
Completed=
var vCompleted= your formula
If( vCompleted=blank(), "Not submitted", vCompleted) That worked! Thank you so much!
- olgad
Please kudo and accept as a solution, thank you!
