Sheet Summary field, max date, ignore blank cells

Hi, I have a sheet with active jobs, some are scheduled and some are not. I want the Sheet Summary field to show the furthest date listed, but some of the rows do not have a date in the selected date column, and I want to be able to select the entire column to pull from so I don't have to expand the selection every time because new rows are added regularly. Below is the formula I tried to use, but it produced an "invalid column value" error. How can I pull the max date from a column that is updated frequently and has new rows added frequently?

This is the formula I have in the field right now =MAX(COLLECT([Install Start]:[Install Start], [Accepted Status]:[Accepted Status], "Scheduled")). I tried to collect dates only in those rows where the Accepted Status column was Scheduled, because this would mean there is a date available to pull from the Install Start column.

Thank you,

Find more posts tagged with

Sheet Summary

Accepted answers

All comments

Paul Newcome

Make sure the Sheet Summary field you are putting the formula in is set as a date type. If it is, double check the column you are referencing to make sure it is a date type column with actual dates in them (and not text strings that just look like dates).

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.