Stop counting days when a row is approved

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.

Screen Shot 2021-12-10 at 11.42.50 AM.png

Screen Shot 2021-12-10 at 11.43.08 AM.png

Thank you!!

Find more posts tagged with

Accepted answers

All comments

J.H. Lim

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

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.

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.