- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 17, 2024 03:39 PM
If I use this formula:
I get this result when {Body: Left Foot} is NOT empty, WHICH IS WHAT I WANT:
But when {Body: Left Foot} is EMPTY, I get this result that has an extra COMMA:
When I take out the comma in the second IF statement, then there's no commas at all whether or not {Body: Left Foot} is empty.
So... what's up with that? Shouldn't it ONLY put the comma IF there's content in {Body: Left Foot}?
 
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 17, 2024 04:18 PM
Hmm not sure either. Try a formula like this:
{Whole-Body Conditions} &
IF(NOT(
{Body: Left Foot}=""),
", ") & {Body: Left Foot}
Not sure if this is what you're looking for, but let me know!
Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 17, 2024 03:48 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 17, 2024 04:18 PM
Hmm not sure either. Try a formula like this:
{Whole-Body Conditions} &
IF(NOT(
{Body: Left Foot}=""),
", ") & {Body: Left Foot}
Not sure if this is what you're looking for, but let me know!
Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 17, 2024 05:49 PM
Worked like a charm, thanks!
