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!

 

 

Tags:

Comments

This discussion has been closed.