Timeline Display "Date Needed"?

[Kit_Kollmeyer]

I’ve set up this task list with dependencies, start and end dates. From it, I added a new table in timeline display. Even though every row contains and start date, and is functioning perfectly in table view, most of the rows in timeline view have a red dot that says: “Date Needed: This row does not contain a valid start date”

I have allowed anyone to view it at the link below: The table and timeline display below it are on the 2113 Isabella page:
Serious Fun Ultimate supamega Project Management Project

Any thoughts?
Thanks,
Kit

[Pch]

Hi @Kit_Kollmeyer

The problem seems to be in your [Task Start] formula , specifically, the True part of your If()

thisRow.Predecessor.[End Date] 

… as this returns not a date but a list of dates

[Small tip: look a the “calendar” icon next to “End Date” … It looks “multiplied”… ]

Which comes from the fact that your Predecessor lookup is a multi-select one .

If you toggle Off the multi-select option in your lookup (as you don’t seem to need it, considering your setup), you’ll actually get a date (instead of a list of dates)

[See how the icon next to “End Date” changed from a “multiplied one” to a simple regular calendar icon …]

And the Timeline should work as expected

[Kit_Kollmeyer]

Thanks @Pch that makes sense. I’m pretty new to Coda, how do I toggle off the multi-select option on the lookup?

Thanks,
Kit

[Pch]

No problem @Kit_Kollmeyer !

@Kit_Kollmeyer

how do I toggle off the multi-select option on the lookup?

You’ll find the concerned toggle in Lookup options

An then → Allow multiple selections
(That’s the toggle I was referring to earlier )

[Kit_Kollmeyer]

@Pch Thanks so much! That was the issue, it’s working great now!