Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 23, 2024 03:31 PM
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!
Solved! Go to Solution.
Aug 23, 2024 08:33 PM
@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) & "%"
Aug 23, 2024 04:14 PM
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?
Aug 23, 2024 08:33 PM
@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) & "%"
Aug 24, 2024 10:58 AM
Sometimes, we do these things so often that we over complicate what's right in front of us. Thank you both, @Mike_AutomaticN + @TheTimeSavingCo !