For starters, is there a particular reason you are storing unit checkins in separate Tables instead of the same Table with multiple Views?
Really seems like you should have this info stored in the same table to begin with, and use View filters to show one unit at a time, with one unfiltered view showing all units.
Hi @Kamille_Parks thank you for your response and really appreciate your suggestions. I’ve tried keeping all units in the same page but It’s really an inconvenience for me as I have 16 units and a bunch of bookings to deal with. Also I wanna keep track of progress of every individual unit.
Do you think using excel formulas can help?