Flag By Date Column 6 Weeks or Greater in the Past

Actual Goodfella
Actual Goodfella ✭✭✭
edited 12/09/19 in Formulas and Functions


We have an order intake sheet that has an "Order Date" column and a Status Column. One of the ten selectable statues is "Complete"

What is the formula that I can use in a flag column to say - Flag any with an Order date 6 WEEKS OR GREATER, and Status NOT EQUAL to Complete? 

Thank you so much in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!