formula to distinguish decimal versus percentage (i.e. 1 versus 100%)

I have a report that combines many sheets. Sometimes the values entered as 1 rather than 100% (or .75 rather than 75%). The report is an input into Tempus (Smartsheet partner) and it makes a difference to their application.

Is there a way to determine that a value is NOT a percentage? Or require entry of a percentage, or some similar way to prevent non percentages in a column?

Thank you

Find more posts tagged with

Formulas

Integrations

IT & Operations

Product Development

Conditional Formatting

Importing and Exporting

Enhancement Request

Comments

Mehmet Zengin

Hi,

If they are expected to select milestone percentages only like %25,50,75 and 100 then I would suggest changing the column type to dropdown and use "restrict to dropdowns values only" feature.

Mike Wilday

This is one of the challenges of smartsheets. Smartsheet columns that are formatted with %'s are actually decimal numbers. Mehmet's solution above will guarantee you get actual percentage text, rather than formatted decimal points.