Sign in to join the conversation:
Hi,
Can someone help me on this formula.
Please check the formula if the % is greater than 100 % its should shows as Yes but in my formula its showing as No.
Hi Jimmy,
It will work if you change the 100 to 1.
Smartsheet looks at the numbers in a column formatted for percentage (for example, a % Complete column) as values between 0 and 1. Use decimal values (examples: 0.25 for 25%, 0.5 for 50%) to get the correct comparison, as opposed to whole numbers.
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Awesome..Thanks Andree
Happy to help!
Andrée
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?
