Newbie who needs help with If, and...


I am working on a formula where I need to be alerted by way of the red flag if a case is older than 180 days and open. The information for the date of incident is in the "Incident Date" column and I have a row with a check box for case closed or open- that row is "Case Closed?". I added a flag column as well.

I also created a report sheet that feeds to my dashboard so I can have it pull this specific data into the dashboard.

I need help with the formula and keep getting stuck. Any assistance would be greatly appreciated :)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!