Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
RYG balls automation

JosyL
✭
Hi,
I went thru existing discussion but could not find my exact need. I would like to automate the RYG balls to change color based on two dates columns.
For exemple if "date issued" is blank I need a yellow ball, if "date issued is not blank but "date released" is still empty then show a red ball and finally if both date columns have information (can also be if "date released" is not empty) then its a green ball.
Can someone help me out on this formatting issue?
Thanks
Comments
-
You may want to check my past comments as I submitted a fairly detailed answer on exactly this topic. Best of luck.
-
Try this:
=IF(ISBLANK([date issued]23), "Yellow", IF(ISBLANK([date released]23), "Red", "Green"))
for row 23.
Craig
This discussion has been closed.