Summarty roll-up sheet - Date error


Hello, New issue here.

I am trying to do a summary roll-up of some sheet metrics. my goal is to publish this to the dashboard for ease of use. All of the metrics are based on the top cell (in green) called "Mother ID". When this number changes, so too does the associated info.

One of the metrics I am trying to pull is a date. I receive an error because none of the other metrics are dates and the only way for the date to pull in, is for the column type to be "Date". I cannot switch this to Date with out creating an error for all the other metrics that are NOT dates.

Is there any way to trick the cell into allowing the date to pull in without changing the column type to "Date"?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!