Populate RGY based on other smartsheet

anilkrag1984

Smartsheet A.PNG

Smartsheet B.PNG

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

Paul Newcome

I posted a solution HERE. It involves using an INDEX/COLLECT to pull the data and then evaluating it in a nested IF statement.