Forum Discussion

Nick221_'s avatar
Nick221_
Frequent Visitor
3 years ago
Solved

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 s...
  • olgad's avatar
    olgad
    3 years ago

    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)

olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
3 years ago

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)