Creating row formula to be repeated on the same sheet

Options

Good day,

can anyone guide me in creating row formulla?. I have a set of data, the normal lies within certain range. When it is above the range, I want it to reflect 'red' bubble, when within the range 'green' bubble and when below, 'yellow' bubble (attached). The issue is that I want this row formula to be repeated on the same sheet with different data. Can anyone assist?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!