Skip to main content

Hello!

I have a formula field set to format as a percent in the table. That field is then part of a linked record lookup field in a table that will trigger automation to send emails. I want to share that percentage in the email. However, when I use the lookup field in the body of the email, it only allows me to include the number as a decimal.  Is there a way to get this to show the percentage?

The original formula field formatted as a percent:

The lookup field settings:

The automation's email token:

The result in the email:

Thanks in advance for any help you can provide!



 

If you do not find any better solution, I’d suggest having an additional field on your table called something like “Formatted %”, where you just multiply the “Reff difference..”  value *100. Then on the body of the email you reference this new field, and you include “%” next to it. Would that help?

If you do not find any better solution, I’d suggest having an additional field on your table called something like “Formatted %”, where you just multiply the “Reff difference..”  value *100. Then on the body of the email you reference this new field, and you include “%” next to it. Would that help?


@Mike_AutomaticN's suggestion works perfectly.  I'd also suggest throwing in a ROUND() to deal with any floating point weirdness as discussed here



ROUND(Percentage * 100, 2) & "%"

 

@Mike_AutomaticN's suggestion works perfectly.  I'd also suggest throwing in a ROUND() to deal with any floating point weirdness as discussed here



ROUND(Percentage * 100, 2) & "%"

 


Sometimes, we do these things so often that we over complicate what's right in front of us. Thank you both, @Mike_AutomaticN  + @TheTimeSavingCo !

Reply


Terms & Conditions