Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 30, 2022 01:04 PM
Hello everyone, thanks in advance for any support. I would like to create a formula that pulls organization names and what state they are in and eliminate the space and have a dash between them. I.E. Akoutis CA would be Akoutis-CA. See attachment
Mar 30, 2022 01:46 PM
{Organization Name} & “-” & {State}
Mar 30, 2022 02:32 PM
It looks like you sometimes don’t have a state, in which case I assume that you also do not want to have the dash.
CONCATENATE(
{Organization Name},
IF({State}, "-" & {State})
)
Mar 31, 2022 06:54 AM
Thank you. This solution worked great. I appreciate it.