LemonSorbet - profile

LemonSorbet · Jun 21, 2024

I tried to create an Automated email, and I don't know how to create a date time format nor rounding number.1. I created new fields with DateTime_Format, but when I put it in the email, nothing appear.2. I also round number in the number field and it...

LemonSorbet · Apr 24, 2024

I'm new here so I do not know that many formula. I imported my tables from excel and I have it generate name of the product with product name + weight. However, I want the numbers that are generated in 2 digits format. And here is my current formula ...

LemonSorbet · Jun 21, 2024

I already edited the formula to Round or Round Down, both won't work in the automated email.

LemonSorbet · Apr 26, 2024

The first weight part has to be INT though, or it will increase the number.{productname}&" "&INT(weight)&"."&RIGHT(''&ROUND(weight*100),2)

LemonSorbet · Apr 25, 2024

You're just so INCREDIBLE. THANK YOU

LemonSorbet · Apr 25, 2024

I've already tried this one, I had replied to another guy that some numbers are still incorrect. I added more digit in weight field to see if there are numbers behind it, but there isn't any. I tried to contact the support team too, but they havn't a...

LemonSorbet · Apr 25, 2024

I copied your formula and pasted it, but parts of it still gave incorrect results

User Statistics

User Activity

Automated Email: DateTime format and Round Numbers

I need a formula for 2 decimal digits mixed with text

Re: Formula format not displaying correctly in email automation

Re: I need a formula for 2 decimal digits mixed with text

Re: I need a formula for 2 decimal digits mixed with text

Re: I need a formula for 2 decimal digits mixed with text

Re: I need a formula for 2 decimal digits mixed with text