epicmike2835 - profile

epicmike2835 · Jul 17, 2024

If I use this formula:IF({Whole-Body Conditions}!=BLANK(), {Whole-Body Conditions}, "") & IF({Body: Left Foot}!=BLANK(),CONCATENATE(", ", {Body: Left Foot}), "")I get this result when {Body: Left Foot} is NOT empty, WHICH IS WHAT I WANT: But when {Bo...

epicmike2835 · Jul 17, 2024

Worked like a charm, thanks!

epicmike2835 · Jul 17, 2024

It appears that it is caused by the referenced Multi-select field {Body: Left Foot} but I'm still not sure how that's possible if that field is blank it still produces a comma.

epicmike2835 · Feb 03, 2024

Worked thanks!

epicmike2835 · Feb 03, 2024

I have checked and rechecked this it is saying it is an invalid formula

User Statistics

User Activity

Using Concatenate with Multi-selects Leaving an extra comma...?

Re: Using Concatenate with Multi-selects Leaving an extra comma...?

Re: Using Concatenate with Multi-selects Leaving an extra comma...?

Re: Random number functions

Re: Random number functions