Iterative For loop? SUMIFS?
Hi all, I am a little stuck on capturing data without adding additional columns/helper sheet. I need to compare the 2 entries of inventory audit in the same column one by one. To do that I can think of using an iterative For loop. With the example attached below:
- Is it possible to iterate each row, [audit#]1 - [audit#]2... [audit#]2 - [audit#]3...?
- Is it possible to have variables? like a counter/Accumulator?
- If API is needed, any recommendations?
May I please know how I can achieve my goal, which is to obtain Storage A's consumption amount?
Thanks!
Answers
-
You could do this with a series of IF() statements that evaluate your criteria and output based on the result with the operators you need
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
how about the scalability with using If statements, we are expecting audit numbers to go to 1000+?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!