Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula Help Needed

Cecily Hill
edited 12/09/19 in Archived 2017 Posts

Hi everyone,


Need some help. I'm sure this is a simple formula ... but I'm not Excel (or Smartsheets) savvy enough to figure it out.


I have a DATE column, and I have a FLAG column. If the date entered in the DATE column is more than 7 days in the past, I want the FLAG to appear in the flag column. If the DATE entered is less than 7 days in the past, then I want the flag to disappear.


Is this doable?


Thanks in advance for your help!





This discussion has been closed.