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.



=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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!