If Formula not working

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

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!