Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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.
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
I am extremely frustrated and disappointed with my current Smartsheet experience. I have paid for a Pro subscription, I am the owner and administrator of my account and sheets, and I have confirmed I am logged into the correct account. Despite this, Smartsheet is not recognizing my Pro subscription, and I am unable to…
