Make calculations from 3 different sheets
Hey, I have 3 sheets: Holidays, Quarterly planning and Teams Vacations.
I want to sum the VACATION DAYS (in holidays sheet- picture no.3) to col Holidays (in Team Vacations sheet- picture no.1), BUT only those who are on the same Q and same Team name and also match with the dates that in Quarterly planning sheet (picture no.2).
Is that even possible?
I tried this formula:
=SUMIFS({BW Holidays Range 1}, {BW Holidays Range 2}, >={Quarterly planning Range 1}, {BW Holidays Range 5}, Country@row, {BW Holidays Range 4}, <={Quarterly planning Range 2}))
but now I need to change manually the dates range according to the different teams in Quarterly planning sheet)
Thank you very much
Answers
-
@Nitzan You can't cross reference multiple sheets in the same formula. You would need to create some helper columns to pull in data from the various sheets and operate on it that way. So, it should be doable what you want to achieve, but will require some helper columns.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!