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 help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 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!