Mean Time Between Two Dates from Form Submission


Hi Community,

I'm attempting to find the average downtime of an asset between dates from a form submission for the month. For example below, I need to find the number of days between the "OOS Tag Removal Date" and "Date OOS Tag Applied", based only on all entries for "Asset ID" FD-001201 where the "Reason for OOS" is Failure, then average that number for each month. Honestly, I don't even know the best way approach this.

That average will then be provided on my metric sheet below under the MTBF for each month to trend reliability:

Any help setting up this formula would be greatly appreciated!

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!