Formula to have status "ball" change color for blank cell

02/09/18 Edited 12/09/19

I would like to have the status "ball" color change to red if the column cell is blank and green if the column cell has a date entered in it.





  • Mike WildayMike Wilday ✭✭✭✭✭

    Try out these steps: 

    1. Create a new column or identify one that has the RYG balls
    2. Make sure your column type is set to RYG balls by right-clicking on the header > Column Properties and choose Symbols > Status > RYG
    3. Then use the following formula in that column... *Note - the formula is set up for row 24. Change the number 24 to the row you desire. 

      =IF(ISBLANK([Column Name]24),"Red", IF(ISDATE([Column Name]24, "Green", "")
  • Mike WildayMike Wilday ✭✭✭✭✭

    Try adding the following formula to your RYG ball symbol column. The formula is set up to check row 24. Adjust the row number and the column name for your own row and column.

    =IF(ISBLANK([Column Name]24), "Red", IF(ISDATE([Column Name]24), "Green"))

Sign In or Register to comment.