How to apply the same 5 different criteria's in conditional formatting for multiple columns quicker

Heba Hallak

Hi,

I have set up a smartsheet to measure the performance of staff.

So

0 = not evident

1= somewhat evident

2 = Evident

3= Above Expected

Once the performance of a staff is observed, the observer keys in either, 0, 1, 2 or 3 etc under the persons name. There are over 30 different criteria's to look at.

So Mary might be a 1 in criteria 1 (column 1) but a 3 in Criteria 2 (Column 2)

Andrew might be a 3 in Criteria 1 (column 2) but a 3 in Criteria 2 (Column 2).

Once a number is keyed in, I want the cells to turn 0 = Red, 1 = yellow, 2= Orange and 3 = Green (i don't want the row to turn, but the cell as each cell will have a different measurement).

I need it to be a number format so I can get the average score.

I know how to use the conditional formatting, but if i had to do 4 criterias for each column x 30+ columns it will take me a long time to do.

Can someone please help?

Thanks

Andrée Starå

Hi Heba,

Unfortunately, I think that is the only way to structure it.

Please submit an Enhancement Request when you have a moment to have your vote added

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!