formula
Hi Guys
I am after something simple
I want to add up production figures from the 01st of the month to the 15th of the month - then work out a percentage of that
that percentage will then form part of an alert to prod managers
Answers
-
A SUMIF Function should be able to do this for you!
I see that you're using hierarchy, so we can take the CHILDREN of this section as the Range to look in to each time. You can then specify what column to look at inside of the CHILDREN Function.
Try something like this:
=SUMIF(CHILDREN([Primary Column]@row), <= 15, CHILDREN(Actuals@row))
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.2K Get Help
- 452 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 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!