Help me to fixing the formula.
Hi there,
I'm getting wrong output in result column, please check and help me to understand the formula for 'Repeat Reactions'.
please check the below explanation.
I want check the how many no of Repeated Reactions for each Target code and each Step number.
Target Code Column has unique set of ID's:
Step # Column has Step ID's(Step 1, Step 2, Step 3...)
Batch size column has quantity(50,5,20...)
Logic:
If Batch size is less than 25mg, No Action required.
If Batch Size is more than 25mg, then count the number of reactions for Each step.
If No of Reactions Per Step is less than 2 times, No Action required
If No of Reactions Per Step is greater than 2 times, consider it as "Repeated Reaction".
Thanks
Shaik
Answers
-
It looks like it is working to me. Exactly what is wrong with it?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!