Backslash not appearing

Hi there.

I am trying to write an if formula ( =IF([Question 2]@row = "C:\Desktop", 1, 0) ; however, as soon as I hit enter, the formula gets saved as ( =IF([Question 2]@row = "C:Desktop", 1, 0) ). The backslash (\) in the text between the quotation marks won't appear, so the formula becomes wrong. I don't know why the the backslash keeps disappearing.

Thank you

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!