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

swaldon

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

Cleversheet

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.