Formula for checking a checkbox when a row is updated within the last 4 days

Options

Can you help create a formula that will check the "Agenda Updated" column when the modified by date is within 4 days of today?

Tags:

Answers

  • Cleversheet
    Cleversheet ✭✭✭✭✭✭
    Options

    Try this, or some version of it:

    =IF(TODAY() - [Modified By]@row < 4, "", 1)

    It's rather odd that you've labeled that column [Modified By] given that the date a row is modified is usually in the [Modified] column, and [Modified By] collects the email (or other actor, such as cell-link or automation) who modified that row.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!