Sign in to join the conversation:
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!!!!!!
Try out these steps:
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"))
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?
@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.
Thank you, James! I copied this into a current status cell and it said "incorrect argument set" ?
@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.
THANK YOU!!!
Hello! I'm currently creating formulas for a gift register to document the price ranges we have and how many are in each category. My categories are: £0 - £50 £50 - £100 £100 - £200 £200 + However, the formulas aren't pulling back all the data accurately because some of the cells include text too like 'less than £500' or…
I am struggling to create a formula for the RYG symbols. I would like to base it off percentage complete and due date. What I am looking for is: Red = Due date <2 days less than .90 and anything past due Yellow = Due date < 4 days less than .50 All other green
Hi there! Can anyone kindly please help me with this - I'm new to SmartSheets and having trouble working out formulas… In one column I have dates that Volunteers started volunteering with our company. The second column I used the following formula to get the number of years that it totals: =YEAR(TODAY()) - YEAR([Vol Start…
