Help

Re: Combining IF and LEFT formula -- not working.

1375 1
cancel
Showing results for 
Search instead for 
Did you mean: 
GrahamW
6 - Interface Innovator
6 - Interface Innovator

Hi all, Im struggling to figure out why a formula in my table produces a blank response vs the intended result... 

I can provide more context if needed but suspect the error is more obvious to some of you and context is irrelevant. 

LMK if context is needed. 

 

The formula is: 

IF({Junction}=1,LEFT({Status},1) & [Product}," ")


'Junction' field can have only two possible results 1 or zero. I would like that if a record contains a 1 in this field, that this new field formula produces a text string that combines the status and product, (eg "Ongoing - Product A") 

It's not doing that though... it's producing just " ") 

What have I got wrong? 😞

3 Replies 3

Hey @GrahamW

Based on the details you provided, I created the following:

Snag_3ac4fc6b.png

Here's the formula that I used:

IF(
    {Junction},
    IF(
        {Status},
        TRIM({Status}) & IF(
            {Product},
            " - "
        )
    )
    &
    IF(
        {Product},
        TRIM({Product})
    )
)

I'm actually a bit surprised that your formula field let you create the field with that formula you provided in your post because your Product field name is wrapped with mismatched curly/square brackets.

Snag_3acd4eca.png

Ben, Im giving you kudos, but want you to know that the error was me... I was referencing the wrong GD field. 

The bracket you reference was a transcription error on my part, otherwise it works if I input the right field. Thanks for trying, sir. 

GrahamW
6 - Interface Innovator
6 - Interface Innovator

Ben, this is the result.. and what I was looking for (sensitive info covered) 

GrahamW_2-1682530431290.png

 

but if you know how I can get it to look like this, it would be EVEN BETTER

GrahamW_3-1682530486618.png

One field that isn't visible that is a commonality amongst these records is the one that lists the junctional relationship. Mentioning that as I believe that it is an important detail to achieving the look