Sheet Summary Formula
Josephine
✭✭✭✭
Ok I have 3 sheet summary formulas that I am trying to make into 1 formula - is this possible?
=COUNTIFS([ESG Core - 4 units to pass]:[ESG Core - 4 units to pass], >=4, [Start date]:[Start date], <TODAY(-180))
=COUNTIF([Start date]:[Start date], <TODAY(-180))
=SUM(ESG# / [ESG %]#) * 100
It works as 3 but would look tidier in the sheet summary and be less confusing as 1 formula. Any suggestions?
Tags:
Answers
-
Hi @Josephine - Yes, it is possible. Just create another summary sheet field that takes the sum of all of these 3 separate summary sheet formulas - =SUM() in the brackets, just select the summary fields you want to add into one.
Hope this helps,
Thanks,
Ipshita
Ipshita Mukherjee
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!