- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 28, 2025 11:07 AM
I need the dollar amounts on our automated emails to be automatically rounded to the nearest cent. The automated email is pulling these figures from fields in airtable that have formulas associated already, and they are set to round to the nearest cent/hundredth, however when they come through on the automated email suddenly they include an extra place value "thousandth," and do not provide thousands comma markers or dollar signs. I do not know how to combine a ROUND formula on top of the formulas that are already on the fields. Can someone help?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 28, 2025 01:14 PM
have you tried wrapping in a ROUND and multiplying by 100 then dividing by 100? e.g .
ROUND(
({Settlement Amount} - Deductible - {Existing Claim ACV} - {JPA Fee for Settlement Email} - {Shingle Sample Company Cost} - {Tarp Fee} - {Umpire Fee}) * 100
) / 100
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 28, 2025 03:48 PM
You can fix this by wrapping your existing formula inside the ROUND() function to ensure it rounds to two decimal places. Then, use & "$" to add a dollar sign and TEXT() to format with commas. Try this:
This will round the amount correctly, add the dollar sign, and include commas. If you need help applying it to your specific formula, let me know! 😊
