Matching a percentage dropdown entry

I've got a pretty simple requirement which I'm struggling with. I have a dropdown defined with % values for completion (ie 100%, 75%, 50% etc) and I want to create a formula which searches for completed tasks (ie any cell with 100%). I imagine this is pretty common.

However, the cell type doesn't seem to be textual, nor does it seem to behave as a normal number. If I use a simple ISNUMBER() function for the cell in question it returns TRUE, but if I then try to do an =IF(Status1=100%, "Complete","Incomplete") I get 'Incomplete' even when the value is 100%. Likewise other numerical comparison operators such as > don't seem to recognise it as a number.

I can't find any functions to convert a number to text, and as it's a number type the usual FIND function doesn't work.

Any ideas?

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi,

It's because you cant check percentage in the formula. It has to be input as numbers. 1=100%, 0,75=75% and so on.

=IF([%]@row = 1; "Complete"; "Incomplete")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

egrigson

That does the job, thanks very much for the speedy response!

Andrée Starå

Great!

I'm always happy to help!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Dashboard not updating
Hello Smartsheet Community! I created a formula that tracks the number of days away from the deadline that I posted on my dashboard as a visual for my students. =IF([Deadline Date]@row < TODAY(), "🔴 Past Due (" + ABS([Deadline Date]@row - TODAY()) + " days ago)", IF([Deadline Date]@row = TODAY(), "🟠 Due Today",…
Sheet Summary Formula Help
Hello, I am trying to get this formula to work but am not having any luck. When I remove the last @cell….text below the formula works great. When I add it in I get an error. Any ideas? =COUNTIFS([ACCT READINESS STATUS PLV]:[ACCT READINESS STATUS PLV], OR(@cell = "PENDING LOCAL CAH", @cell = "ADDITIONAL REVIEW NEEDED LOCAL…
How to use previous cell value (from cell history) in a formula?
I have seen this question asked multiple times in the forum, but I couldn't find any clear answer provided in the answers. Please excuse me if a solution already exists, but if not, will someone please let me know if it is possible to use a previous cell value (from cell history) in a formula? I am specifically trying to…