Forum Discussion
Multiple IF Formula
Hi! Below is my full if formula, for now Im just testing this one: =IF([HOTEL]="CVS - Centralværkstedet","mailto:info@t.dkk","Test") Pretty basic, but it is not working. Error message: " ...
Hi,
I am trying one single line.
Does it work for you if you try with letters/alphabeth?
I am trying one single line.
Does it work for you if you try with letters/alphabeth?
Yes, I showed the formula that is working for me. It looks identical to your formula, but I also get the same error if I just copy/paste your formula. I think there is a hidden character causing the error, but rather than troubleshoot that, just recreate the formula one piece at a time, which will hopefully bypass the bad character.
- Sadly this nesting limit is not good for me.
I am now trying to use lookup columns instead. But I need Power Automate to Insert the Microsoft Form entry into that lookup-column. That is also an issue now.
Thanks for your help.