Time reference?

I’m trying to make an app that tracks and keeps tour/concert info.

I’m having a hard time because I always have to enter the same times over and over in different sheets - itinerary, advance, show details, etc

Because as of yet, I haven’t figured out a way to reference “times”, is there a way to do this? I always just get errors saying that time is not a yes/no/list.

Say, I have all of the times already listed in the “shows” table.
Each show is linked to an itinerary and advance by the [show id]

Usually I’d reference or dereference the “show” table via the formula box…but I can’t get it to work

Am I doing something wrong? Or is there not a way to reference a time that’s already been entered on another table?


TIA!

0 4 186
4 REPLIES 4
Top Labels in this Space