Hi All - Hoping someone can help me figure out a formula to create the result outlined in the attached image. Involves stringing together text from fields, as well as replacing spaces with underscores, and shortening some Names to be Initials Only, e...
Hello, I am sending an email out using SendGrid. I have a filed that is a link of multiple linked records. It strings them all together with commas between, which is really exhausting to look at, i.e.:
“Day 1, Day 2, Day 3, Day 4, Day 5”
I would like...
Hi, Does anyone have a formula to format a date to include the “st” “nd” “rd” “th” ?
For example, I would like 3/21/2022 to read as Monday, March 22nd
I can only figure out how to do Monday, March 22
Thanks!
Tom
Here’s the formulas:
REGEX_REPLACE(
CONCATENATE({Project Code},"_",{Project Name},"_",{File Name Helper: Photo Initials},"_",{File Name Helper: Athlete 1st Initial},{File Name Helper: Athlete Last Name},"_","Look-",{Look #},"_####"),
" ","_")
REGEX_...
Hi @Databaser, I was able to figure it out, but I had to create a few separate formulas to do so. I couldn’t figure out how to put all these formulas into 1 field. Ideally that’s what I’d like to do. @Justin_Barrett , any help would be super apprecia...
Even if there’s a comma at the end, it should still recognize the email as a valid entry when composing. BTW, most email programs, including outlook, require a " ; " between addresses and won’t working with a comma