=ISBLANK, =IF??

Mary Shevlin
Mary Shevlin ✭✭✭✭
edited 04/16/20 in Formulas and Functions

I need help working out a flag formula, please.

If [Cell] contains anything (is not blank), turn on the star

If [cell] is blank leave star off


I have tried these - none work:

=ISBLANK([Date Invoice Approved & Who Requested]@row, "Off", "", "On"

=ISBLANK([Date Invoice Approved & Who Requested]@row, "0", "", "1")

=IF([Date Invoice Approved & Who Requested]@row = <>, 1, 0)

=IF([Date Invoice Approved & Who Requested]@row = "<>", 1, 0)

=IF([Date Invoice Approved & Who Requested]6 = "*", 1, 0)

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!