If Formula not working

Kate Hayes

Hi

I cannot get the below if calculation to work, any suggestion where I have gone wrong?

=IF([Customer]@row "M&S", [Trial Date]1+1, IF([Customer]@row "JS", [Trial Date]1+12, [Trial Date]1+8))

Thanks

Kate

Andrée Starå

Hi @Kate Hayes

Try this. (You forgot the equal signs)

=IF([Customer]@row = "M&S", [Trial Date]1+1, IF([Customer]@row = "JS", [Trial Date]1+12, [Trial Date]1+8))

Did that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Kate Hayes

Try this. (You forgot the equal signs)

=IF([Customer]@row = "M&S", [Trial Date]1+1, IF([Customer]@row = "JS", [Trial Date]1+12, [Trial Date]1+8))

Did that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Kate Hayes

Hi Andree

Yes = would be useful - all working now, thank you for your prompt reply

Kate

😊

Andrée Starå

@Kate Hayes

Excellent!

You're more than welcome!