How can I calculate and display a percentage ratio between two numeric columns in Smartsheet formula

Peterson

I have a Smartsheet with two text/number-type columns:

• Credit Consolidated
• Credit Required by Proposal

I’d like to add a third column (Formula type) that divides Credit Consolidated by Credit Required by Proposal and shows the result as a percentage string (e.g. 130%). Smartsheet doesn’t offer native percentage formatting for formula columns, so I’ve tried a couple of approaches:

1. Using TEXT
   
   =IFERROR(
   TEXT(
   [Credit Consolidated]@row / [Credit Required by Proposal]@row;
   "0%"
   );
   "0%"
   )
   
2. Multiplying, rounding and concatenating
   =IFERROR(
   CONCATENATE(
   ROUND(
   [Credit Consolidated]@row / [Credit Required by Proposal]@row * 100;
   0
   );
   "%"
   );
   "0%"
   )
   

However, both formulas either return “unparseable” or unexpected values. I know I need to wrap the division in IFERROR, and I’m using the correct column names, but I can’t seem to get a valid result.

• What is the correct syntax (using the appropriate argument separators for my locale)?
• Is there a built-in Smartsheet function or workaround I’m missing to format a formula result as a percentage string?
• How can I reliably display something like 130% (or with 1–2 decimal places) without errors?

Any guidance or working formula examples would be greatly appreciated.

Paul Newcome

You can do the basic division and then format the column to show as percentages.

=[Credit Consolidated]@row / [Credit Required by Proposal]@row

Paul Newcome

You can do the basic division and then format the column to show as percentages.

=[Credit Consolidated]@row / [Credit Required by Proposal]@row

Peterson

I tested it and it worked, thank you so much, Paul!

Paul Newcome

Happy to help. 👍️