nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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

c-justin.grey37336

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.

PLEASE HELP!!!!!!

Find more posts tagged with

Formulas

Comments

Mike Wilday

Try out these steps:

Create a new column or identify one that has the RYG balls
Make sure your column type is set to RYG balls by right-clicking on the header > Column Properties and choose Symbols > Status > RYG
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 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"))

alexandra.richardson

Hi! I'm fairly new to SmartSheet and formulas and could use some help. In one column I have "Progress" at the top column and am using the red, yellow, green balls. Next to it I have "Current Status" with some dropdown options (1 - Not Started 2 - In Progress 3 - On Hold 4 - Cancelled 5 - Completed). I want to make it so that if someone chooses the red ball, the current status will move to "1 - Not Started" and if someone chooses the green ball the current status will move to "5 - Completed." Can you help me with that formula?

JamesB

@alexandra.richardson

In your Current Status Column you would need the following formula:

=if([Progress]@row = "Red", "1 - Not Started", if([Progress]@row = "Green", "5 - Completed",""),"")

if either condition is false, you will have a blank in your progress cell.

alexandra.richardson

Thank you, James! I copied this into a current status cell and it said "incorrect argument set" ?

JamesB

@alexandra.richardson My apologies, I added in an extra set of quotations. The formula below should work.

=IF(Progress@row = "Red", "1 - Not Started", IF(Progress@row = "Green", "5 - Completed"))

If you need color for the other 3 statuses, you will need to nest in additional if statements.

alexandra.richardson

THANK YOU!!!

Sign in to join the conversation!

Quick Links

Trending discussions

SUMIFS formula bringing back total of all items, not items in specified date range.
Hello, I'm using a SUMIFS formula to try and get the sum of materials, done during a specific process, during the specified date range of May 04 2026 - May 08 2026. But it continues to total all entries in that column, instead of giving the total based on the provided data. I've also tried using both OR and AND functions…
Creating Project Planning Sheets from a Template, Linking to Master Sheet
I created a master sheet that will list all projects for a department. We will also have a planning sheet for each project in the master sheet, created by copying one of four templates (based on the project type). Each of the four templates will have columns set up and a hierarchy of rows based on phases, workstreams,…
Using a checkbox in formula
Hello All, My existing formula (working correctly) inserts text of REORDER NEEDED or OK option , formula below: =IF([Stock Quantity]32 < [Reorder Level]32, "REORDER NEEDED", "OK") I would like to add a third text insert of "ORDERED" when criteria of a checkbox has been checked in the ON ORDER column -or a date ordered…