Formula to convert date (e.g., 03/13/22) to text/number field (03/13/22) in same sheet?
A sheet that has a Dynamic View includes a date field (Start Date) that Dynamic Viewers need to use as a filter. Since users cannot filter by date fields in Dynamic View, I've added a helper column (text/number) in the sheet but cannot find a formula to pull the dates in the Start Date column into the helper column so Dynamic Viewers can use that field to filter.
Thanks for your help!
Lori F.
Best Answers

@Lori Flanigan Try this:
=[Start Date]@row +""
Adding a blank text value (double quotes) to a numeric or date value converts the cell to text/number.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Perfect! Thank you, Jeff!
Answers

@Lori Flanigan Try this:
=[Start Date]@row +""
Adding a blank text value (double quotes) to a numeric or date value converts the cell to text/number.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Perfect! Thank you, Jeff!

Hi Jeff, hi Lori, the formula =[Start Date]@row +"" didn't work for me. The column where I've entered the formula is a text/number column and returns a date and time instead of a number.
I'm trying to calculate total slack and free slack, which can then be used to calculate late start and early finish, but I can't seem to convert the date fields to a number using the formula above. Any ideas on why?

@Jeff Reisman @Lori Flanigan  meant to tag you in my comment above

@Danielle Dysinger I'm unclear what you mean by "convert the date fields to a number." Can you elaborate?
Smartsheet is able to use date values in date columns to calculate other dates. For instance, if your Date column value was 04/11/23, and in another date field you entered =Date@row + 5 , you would end up with 04/16/23 as the result.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!