Days since last incident

Options
bgreer8
bgreer8 ✭✭
edited 04/11/23 in Formulas and Functions

I've been looking at some older posts but can't find one that matches my specific needs or one that I can find that works, either.

The formula I am looking for to help can be explained as:

I have multiple project sites that are being captured. I need to have a formula that helps populate my dashboard letting me know how many days since the last incident for the specific project. I have an incident date and project number column already in my smartsheet. Incidents are being uploaded as they come in, but I need to ensure its capturing the most recent incident for said project number, and then telling me how many days its been since then.

Any help is appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!