How can I calculate the total days of a column when another column meets a criterion?

Hi everyone,

I need help creating a formula that collects the total days from the date a request is inputted to the day it changes from "Pending" to "Approved".

Dates are registered in the column "Date Initiated"

Status is registered in the column "Review"

I created a "Today's Date" column to subtract the requested date and an "Approval Waiting Time" to sum the net days between the two dates. However, I am struggling to create a formula in my summary that shows total days only when the status is Pending.

Can you help me with this, please?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!