Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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!
Please kudo and accept as a solution, thank you!
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)