Oct 07, 2023 07:08 PM
I am trying to have a formula which give me the possibility to have on the same line two fields separated by a coma. This is tricky, because, i need also to have in the formula that if the field is empty if it not showing the empty space or make a break line.
Right now I have this,
Solved! Go to Solution.
Oct 09, 2023 09:54 AM
Oct 07, 2023 08:10 PM
To check two fields and branch conditionally, use the AND function.
How to use Like this.
IF(
AND({MARQUES},{DESIGNER}),
{MARQUES} & " X " & {DESIGNER} & "\n",
IF({MARQUES}, " " & {MARQUES} & "\n") &
IF({DESIGNER}, " " & {DESIGNER} & "\n")
)
Oct 09, 2023 09:54 AM
Thanks that is great
Nov 30, 2023 10:55 AM
I still have a problem i would like to use REGEX_REPLACE() to remove all white space next to a line break but I do know how to write it correctly.
here's what I have so far and where should insert and write with REGEX_REPLACE (?????)