Formula for "Days since" event

Hi There,

I'm looking for some help with a formula for a sheet summary field. I'd like the field to display the number of days since "today" that a checkbox was checked, based off the date entered in that checkbox's row.

Example based off screenshot: "Today" is 12/4/2023. If the checkbox for Row 66 is checked the "Days Since" summary field would return "3". However, if then the checkbox for row 68 is checked, the "Days Since" summary field would update and return "0".

(the Valid PIR Date row is a row I tried based off searching the forums for answers, I'm not sure if it needs to be there or not. The current functionality has an automation set to populate that row with the date when a Valid PIR checkbox is checked.)

Thank you!

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

Zachary Hall

Hello,

You should be able to do it in your Sheet Summary with something like:

=TODAY()-MAX(COLLECT([Date Received]:[Date Received],[Valid PIR]:[Valid PIR],1))

Hope this helps!

All comments

Zachary Hall

Hello,

You should be able to do it in your Sheet Summary with something like:

=TODAY()-MAX(COLLECT([Date Received]:[Date Received],[Valid PIR]:[Valid PIR],1))

Hope this helps!

tkpdx

@Zachary Hall Thank you very much, works like a charm!

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.