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!!!
Smartsheet Community - I AM STUMPED!! I am trying to do a crosssheet SUMIFS formula with 1 Column and 2 Rows of Data. I need to sum across {Weeks 1 to 104} Column to match : {Helper Column} = Baseline@row Vertical Rows {Month} needs to match Month@row, and Row {Year} needs to match Year@row I have tried SUMIFS, JOIN,…
Hello I am looking to create a Smartsheet formula that returns the following result: Column A "Created Date" - this column type is a Created date and show results with date and time Column B "Received Date" - this column would round up the "Created Date" and just show date, no time. If the "Created Date" was after 2:00pm…
Cant figure out why this is not working. It comes back NO MATCH. I have changed it to true and to 1. Nothing works. HELP
