Formula in Date Column



I am trying to get a date value from another sheet in a date column using Index(Collect(.......),1) function. However, every time I add a formula in date column it converts to text by adding a ' sign.

For Example:

Sheet1 has following columns:

  1. Location
  2. Project
  3. Start Date
  4. End Date





I want to move Start Date and End Date based on project name using Index(Collect(...),1) formula. Though I can move the rows though copy row automation, but I don't need all column in the new sheet. So I am using this formula to copy only selected columns.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!