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...)


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".




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!