Sign in to join the conversation:
Could someone help clean up the following formula:
=IF(AND(TODAY() >= Finish2, [% Complete]2 < 100), "Red", IF(AND(TODAY() < Finish2, [% Complete]2 < 100), "Yellow", "Green"))
Hello,
I'm not sure what you mean by clean up, exactly, but one thing I noticed is that you're using a % complete column and comparing it to 100. Smartsheet treats percentages as decimals, so 1 is 100% and 100 is 10,000% percent.
If your formulas is doing what you expect it to, then change it to something like this:
=IF(AND(TODAY() >= Finish2, [% Complete]2 < 1), "Red", IF(AND(TODAY() < Finish2, [% Complete]2 < 1), "Yellow", "Green"))
Otherwise, let me know what you specifically need to do with your formula and I can assist further.
Hello, I am having trouble making my Dynamic View work. I feel like I am following the instructions but I seem to be the only one able to see the "view". Trying to test this internally before I push out to the customer. I am using a filter that is built into the main worksheet. Anyone have time to review with me? Thank you…
I’m having service provide agreements for different clients, how to implement a e-sign workflow in smart sheet where a document is generated and sent for signature to the clients.
We have MANY sheets to transfer. This is as a result of our company domain changed (hii-tsd.com to hii.com). So we transferred ownership to 3 people (myself included) on the Portal Team, who manage the Smartsheet files. I had a co-worker on the portal ACCEPT the email that was sent to the shared mailbox, and then the…
