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
Hello, I deal with a lot of batch/lot numbers that are automatically generated and start with leading zeros (e.g. 000012345). I'm trying to create a column simply to count the instances of a lot number within the column in order to quickly identify duplicates. The formula I have is =COUNTIF([Lot Number]:[Lot Number],[Lot…
I have a formula in a Smartsheet that will show the last step date completed in one column and then another formula that will show the next step to be completed. The issue I have run into is that if 2 steps are completed the same day, SS is only picking up on the first one and showing the 2nd one as the next step to be…
Hi all - i am building a monthly dashboard with separate columns for each month's status, key takeaways, and next steps. I am wanting to build an automation that says for example: 'your {{current month}} status update is due, your last {{last month}} update was {{status color}}. Please be sure to indicate your key…
