Flag setting

Tinka Louw
Tinka Louw ✭✭
edited 06/15/22 in Formulas and Functions

I need he flag to be activated when 2 conditions are met

E.g if there is a value in a column and no value in another column, the flag must show


  • Brent Wilson
    Brent Wilson ✭✭✭✭✭

    Try something like this..


    You may have issues if you have formulas in cells as they may show as nonblank. In this case, you may want to use something more appropriate for the data like <0, or ISDATE...

    The column where you put this formula must be a symbol with the flags turned on and 1 will cause the flag to show, and 0 will turn it off.

    Brent C. Wilson, P.Eng, PMP, Prince2

    Facilityy Professional Services Inc.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!