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 have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
I want to use a list of account numbers in one sheet for a dropdown in another sheet using Table View. When I select the sheet and column in the dropdown menu, it shows the correct column but is dropping zeros. I have provided a screenshot of the reference column and then what appears in the drop down. Any ideas?
