Sign in to join the conversation:
I need to color a ball yellow if the value in a column is between .05 and .15. If the value in the same column is greater than .15 OR a checkbox is selected, I need the ball to be red. Not sure how to accomplish this. Appreciate your help.
Try:
=IF(OR([Check Box]@row = 1, [Value Column]@row > 0.15), "Red", IF(AND([Value Column]@row >= 0.05, [Value Column]@row <= 0.15), "Yellow", "Green"))
Dear Smart Community, I am experiencing an issue with a specific email ID that is not receiving notifications triggered through workflow automation. However, the user is able to receive emails when I send an update request manually. I have tested several scenarios in coordination with the IT team. For example, when…
I am trying to setup a sheet that can project dates decades into the future. I want a formula that can look the date in the row above, check to see if it's annual or quarterly, then add the appropriate number of months to each row. While testing the formulas, I keep getting stuck on how to add one year (12 months) to each…
I have a form adding new rows to my smartsheet but it doesnt add the next number in the primary key, is there a way to do this?
