Is there a way to add a conditional format to a cell that has a drop down RYG...like project health? If a task date is past due, I want the health cell to change from green to yellow automatically. Thanks for any help!
Hi Linda,
You can achieve this through a nested IF formula, rather than through conditional formatting.
Here's a Smartsheet blog detailing how to create a nested IF to automate RYG balls: https://www.smartsheet.com/blog/support-tip-automate-RYG-balls
Thank you!
I have a sheet accessed by monkeys users who keep managing to muck up a currency column. They are either pasting in amounts from some other source or literally typing in the dollar sign followed by a number, or something. The result is reports that lose their currency formatting. Smartsheet seems to treat these bad entries…
Hi my colleague has imported an Excel spreadsheet and one of the formulas hasn't worked on import. Please could someone let me know if the following Excel formula can be converted into a usable Smartsheet formula? Here it is: =IF(B4<>"", ROW()-1, "") Many thanks, Lee
Hello, I am trying to use the IF formula to perform a date calculation based on a value selected in another column but keep getting UNPARSEABLE error. Here is the formula that I have used. I have also pasted the screenshot for reference. Can anyone help me out on this? =IF([SLA]@row = "Standard",[Feasibility_Start…
