Index Collect Formula for Dates resulting in Invalid Value Error

Molly H
Molly H ✭✭
edited 08/09/23 in Formulas and Functions

Good afternoon,

I am trying to use an Index Collect formula to collect dates that have dependencies. Here is the formula I'm using:

=INDEX(COLLECT({Portfolio Summary | Actual Start}, {Portfolio Summary | Project Number}, [Project Number]@row), 1) + ""

I can confirm that the formula cell is a date column, as well as the referenced column in the portfolio summary. It is also worth noting that the original dates have dependencies turned on. The result is an Invalid Value error.

Any help would be greatly appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!