Dear Team! What is wrong with this statement? #UNPARSEABLE returned

Adedeji Adebanjo

=IF(NOT(ISBLANK([L3 Sourcing Strategy]@row)), [L3 Sourcing Strategy]@row, [Savings Type2])

Andrée Starå

@Adedeji Adebanjo

Happy to help!

Try this and see if it makes a difference.

=IF([L3 Sourcing Strategy]@row <> "", [L3 Sourcing Strategy]@row, [Savings Type]2)

Did it work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Adedeji Adebanjo

I hope you're well and safe!

Try something like this.

=IF([L3 Sourcing Strategy]@row <> "", [L3 Sourcing Strategy]@row, [Savings Type]@row)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Adedeji Adebanjo

Hi Andree,

Thanks for sharing.

I now receiving this message: #CIRCULAR REFERENCE

Thank you

Andrée Starå

@Adedeji Adebanjo

Happy to help!

Try this and see if it makes a difference.

=IF([L3 Sourcing Strategy]@row <> "", [L3 Sourcing Strategy]@row, [Savings Type]2)

Did it work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Adedeji Adebanjo

Hi Andree,

Bingo! That worked! Thanks for your help!

you are a true scholar and gentleman!

Have a nice week ahead!

Regards

Deji

Adedeji Adebanjo

Hi Andree,

One final question i hope! 😊

I am not able to convert it to a column formula. Any Ideas?

=IF([L3 Sourcing Strategy]@row <> "", [L3 Sourcing Strategy]@row, [Savings Type]2)

Andrée Starå

@Adedeji Adebanjo

You're more than welcome, and thanks for the kind words!

It's the direct reference for the Savings Type2. If you could reference that cell in the sheet summary section in a so-called helper field and then reference that one in the formula instead, you'd be able to convert it to a column formula.

Make sense?

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!