Sheet Summary field suddenly started to append date with time of day

A Sheet Summary field that concatenates the next scheduled task name and due date suddenly began this week to append the date (MM/DD/YY) with the time of day (HH:MM). No changes were made to formula.

Example:

Screen Shot 2021-03-05 at 1.42.06 PM.png

Formula:

=IFERROR(INDEX(COLLECT([Task Name]:[Task Name], Actual:Actual, ISBLANK(@cell), Status:Status, "In Progress", Target:Target, MIN(COLLECT(Target:Target, Status:Status, "In Progress"))), 1) + " - " + MIN(COLLECT(Target:Target, Status:Status, "In Progress")), "-")

Anyone else notice this change? Any idea how to suppress the time of day?

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

All comments

Genevieve P.

Hi @Bill King

Is your "Target" column a System Created column that includes the time? If so, you can remove the time out by using the function DATEONLY, try this:

=IFERROR(INDEX(COLLECT([Task Name]:[Task Name], Actual:Actual, ISBLANK(@cell), Status:Status, "In Progress", Target:Target, MIN(COLLECT(Target:Target, Status:Status, "In Progress"))), 1) + " - " + DATEONLY(MIN(COLLECT(Target:Target, Status:Status, "In Progress"))), "-")

If this doesn't work, can you clarify how the data in your Target column is being populated? Is it from another formula, from a date manually selected, a system column, or a form submission?

Thanks!

Genevieve

Bill King

Hi @Genevieve P Inserting DATEONLY worked perfectly. Thanks! I still haven't figured out why the timestamp suddenly appeared (and probably never will).

Genevieve P.

No problem, I'm glad we got it fixed! 🙂

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.