Check the flag

Options
CherylAK
CherylAK ✭✭✭✭
in Formulas and Functions

How can I get the flag column to activate when the date in another column is over 30 days old? I have been trying to do this in "conditioning" but can't get it to work. Thank you

· Share on FacebookShare on Twitter

Best Answer

  • Brent Wilson
    Brent Wilson ✭✭✭✭✭
    Answer ✓
    Options

    @CherylAK

    =IF([Date1]@row < TODAY(-30), true, false)

    Note the formula has to be in a checkbox column to display properly

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

    Facilityy Professional Services Inc.

    http://www.facilityy.com

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!