Populate RGY based on other smartsheet


Hi Paul Thanks I have resolved both the queries but if you help me with the other one.

I have 2 Smartsheets as Smartsheet A and B

In Smartsheet A I want to populate RGY in such way that if Value in Smartsheet B corresponding Theatre and Qtr as below

For ex if ANZ Q1 value in Customer Training Column in Smartsheet B is 8% then in Smartsheet A it should reflect Red

same as below

  • 0-33% Red
  • 33-66% Amber
  • 67 – 100% Green


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!