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'm looking to create a 'dual list' of unique column value pairs. I can create a single list of unique column values with a helper Row # column and the following formula: INDEX(DISTINCT(COLLECT({Epic ART Impacts: ART}, {Epic ART Impacts: Epic ID}, [Epic ID]#)), [Row #]@row)) When pointed at a list with MANY duplicates,…
I have written these hundreds of times but for some reason I am missing something with this one. Simple, trying to count "Health" based on what we call Seq, in this case TSK. Building a metrics sheet for Dashboards. This formula is producing a Unparsable error and I cannot find the error. =COUNTIFS({DSV 3PL Schedule Range…
My goal is the bring in contact information (Name and email address, 2 separate columns) from a reference sheet {Sheet A} to my target sheet {Sheet B}. I've used {Sheet B} as a reference on many other sheets for the same purpose, however, the data on this particular target sheet is inconsistent with the reference sheet.…
