Referenced Dates Not Recognized for Gant View

Options
AnnThompson
AnnThompson ✭✭
edited 04/24/24 in Formulas and Functions

I have a sheet that will need to be a gant view, the sheet is populated by referencing the columns in another sheet, 2 of them are date columns, but it will not recognize them as date columns to show in a gant view. It seems I need just the date in a new, not referenced column for it to recognize it as a date, how can I grab it without having a formula in the new column.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!