How to check multiple cells via a formula

Options
PJay128
PJay128 ✭✭
edited 12/09/19 in Smartsheet Basics

I have two columns one which is a tick column the other is a date column.

I want to add a status column which will update ryg balls.

So if the value in the tick column is 1 i get a green ball if the value in the date column is not blank i get a green ball. And if neither of them have any value the ball is red.

I don't need to have both values to get a green ball just one.

And ofc if i have no value in either i get a red ball.

Cheers

 

Comments