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
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!