Sharepoint formular syntax error

Copper Contributor

Hey im working on a Filtered Lookup list that i need to only use the products that is avalible

i Tried using the Formular:

=IF([Status]="Tilgængelig",[Titel],"") and get mistake in syntax i am at a loss?

pls help




1 Reply

Hello @TechNewbie2020 


try to use ; .


In my case it works with this formula: =IF(ChoiceStatus="blue";Title;"")


Best, Dave