getting date from another sheet gives #INVALID COLUMN TYPE error

Options

Sheet 2



When we click start_date reference sheet then opens reference window as below!

Reference Sheet (Sheet 2)



Sheet 1: Created date id of Date type

Please Assist!

I only want to get the create date into start date.

Date is present in a sheet 1

I'm referencing it in sheet 2 but gives an error

It works if the created date is of text type column

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!