Formula in Date Column

Gulshan Sharma

Hello,

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.

Andrée Starå

Hi @Gulshan Sharma

It's probably because you're using dependencies. (Please see details below)

https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors

In a project sheet, you can enable automated dependency functionality in the following columns:

Start and End Date

Duration

% Complete

Predecessors

NOTE: Formulas aren't allowed in the columns listed above when dependencies are enabled.

Was that the issue?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Gulshan Sharma

It's probably because you're using dependencies. (Please see details below)

https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors

In a project sheet, you can enable automated dependency functionality in the following columns:

Start and End Date

Duration

% Complete

Predecessors

NOTE: Formulas aren't allowed in the columns listed above when dependencies are enabled.

Was that the issue?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Gulshan Sharma

I have turned off the dependencies and the formula is working now. Thanks for the response.

Andrée Starå

@Gulshan Sharma

Excellent!

You're more than welcome!