So I am trying to do a reference or a de-ref but it is not working for me.
I have a main spreadsheet called “Master Client List”.
I also have a Trellis Timesheet spreadsheet, and one of the columns in this is a Ref drop-down menu of the [Client Name] column from the Master Client List.
As we input new rows/forms into the Trellis Timesheet for each client, I want it to be recorded in the Master Client List, so that we know the trellises for that client have been completed.
So I created a column in the Trellis Timesheet called [Trellis Completion].
This will read as “Complete” when a form is input for any given client.
Then I have another column in the Master Client List called “Trellis Complete”.
I would like this to show the same value as the [Trellis Completion] column in the Trellis Timesheets spreadsheet, for the referenced client.
So if we complete Betty Smith’s trellis, I want it to show as “Complete” in the Master Client List under Betty Smith, even though all we have to do is enter information into the Trellis Timesheet.
I have made sure that the ref for [Client Name] is there (it’s a drop-down list in the form), and the Client Name is both the key and the label in the Master Client List AND in the Trellis Timesheet.
However, when I try to do a de-ref, for example [Client Name].[Trellis Completion] it does not work.
It says it is invalid.
I am putting this in the app formula field.
And I have tried making the type both a Ref as well as Text.
Neither have worked.
What am I missing? Your help is greatly appreciated. Many thanks, Miranda