I have created a three table airtable, for project planning.
Projects have a Start Date and End Date
Resourcing links to Projects, and has a Start Date Override and End Date Override, as well as two Formula fields, Start Date and End Date, which choose either the project Start and End dates, or the overrides if set. Ie
IF({Start Date Override} = BLANK(), {Start Date (from Project)}, {Start Date Override})
I have created a Gantt view using these formula fields as Start Date and End Date, which works fine as a normal user. However when I try to create a shared view, I see instead “Start date field is hidden or invalid”
Table setup
Gantt Setup
The error :frowning:
Any help would be appreciated