getting date from another sheet gives #INVALID COLUMN TYPE error
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
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
Help Article Resources
Check out the Formula Handbook template!