Hey AT community,
I can’t figure out why this formula isn’t working – AT is telling me it’s an invalid formula:
CONCATENATE({Full Name copy}, IF(NOT({Full Name copy}), Org), " - $", {Received Amount}, " - ",DATETIME_FORMAT({Date Received}, “D/M/YYYY”))
I want the formula to be rname or org] - {$received amount} - date received
Ex. John Smith - $5,000 - 09/02/2022
Thank you!
Aside from recommending you simplify your IF statement, I believe your issue is with the curly quotes around your date format.
CONCATENATE(
IF({Full Name copy}, {Full Name copy}, Org),
" - $", {Received Amount},
" - ", IF({Date Received}, DATETIME_FORMAT({Date Received}, "D/M/YYYY"))
)
The IF around the date format will avoid errors for when no date is inputted.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.