Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 14, 2021 02:22 PM
Hi there,
As you can see in the picture I’ve two sheets here. So the sum of Sheet 1 is $2890 and sum of sheet No 2 is $3400. IS there any way to combining the sum together and view them at once?
Thanks in advance!
Jul 14, 2021 05:39 PM
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.
Jul 14, 2021 10:13 PM
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?
Jul 14, 2021 10:27 PM
Nope, because this isn’t Excel and (most of) the formulas don’t match.
Are you using Filtered Views? That’s precisely what they’re designed for: showing one “thing” at a time.
You’d have 17 views: one for each unit, and one showing all units.
Jul 14, 2021 10:42 PM
I’ve tried using filtered view but not for like in broad way for every unit. But I’ll do it now amd see how that goes along. Thank you for your help.