imtonydillard✭

@Genevieve P. Mega thanks for your help with my need. IT WORKED! You are awesome. Cheers, Tony

Hi @Genevieve P. I am sorry for the delayed response. Thanks for the recommendation. It works, but... In the instance where Required States row containing AL, AK, AR, CO, I need the Ready box to be checked. My reason for this is because AL , CO & CT need to be ignored since they are not checked in States To Be Filed. Is…

@Andrée Starå I am the owner of the workflow. It is shared internally. The only activity in the sheet other than mine is an icon (two small circles) and when I hover over it a small box opens that reads API - Other Client.

@Paul Newcome I am the owner.

@Kelly Moore is the 2022's most recommended pain reliever for migraines caused by smartsheets.

@Kelly Moore Mega thanks for your help on this. It worked for my on the first try and because of your guidance I was able to figure out how to write a vlookup formula to do the same. =INDEX({sheet 2 Risk column}, MATCH(Carrier@row, {sheet 2 Carrier column},0)) =VLOOKUP(Carrier@row, {CCIndex Repository Range 1}, 13, false)

Mega thanks @Jeff Reisman .

@Jeff Reisman

Mega thanks Neil Watson. It worked. U DA MAN!

Mega thx Genevieve P.