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

TechNewbie2020_0-1715866976064.png

TechNewbie2020_1-1715867030941.png

 



1 Reply

Hello @TechNewbie2020 

 

try to use ; .

 

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

 

Best, Dave