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
0 -
Perfect! Thank you, Jeff!
0
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
0 -
Perfect! Thank you, Jeff!
0