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

Bill King

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:

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?

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! 🙂