Stop counting days when a row is approved

Options

Hello all!!

Im hoping to get some help with calculating a day count for my sheet.

Currently, we have "=TODAY() - [Date Received]@row," in the "Days in queue," column which counts the days from when we receive an action to the current date, but we would like to add a formula to where the count stops once the "Approval Sent" column gets a date added.


Thank you!!

Answers

  • J.H. Lim
    Options

    Try:

    =IF([Approval sent]@row<>"",TODAY() - [Date Received]@row,"")

    Basically:

    If the Approval Sent cell for that row is not (<>) blank (""), then show today's date minus the date received for that row. If the Approval Sent cell for that row is not not blank (should be filled in when Approval gets sent out), then display a blank cell ("").

  • Lisbeth Fuentes-Fernandez
    edited 12/10/21
    Options

    Is there any way the days can be counted in the "Days in queue" row and it stop counting once there is a date added in "Approval sent" column?

  • Genevieve P.
    Options

    Hi @Lisbeth Fuentes-Fernandez

    J.H. Lim is on the right track! You can add an IF statement to say that if the cell is blank, run your current formula. All that's missing is what to do if the [Approval sent]@row is NOT blank (so it has been sent). In this case, you can subtract the Date Received from the Date Sent, instead of Today.

    Try this:

    =IF([Approval sent]@row = "", TODAY() - [Date Received]@row, [Approval sent]@row - [Date Received]@row)

    Let me know if this makes sense!

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!