What is wrong with my IF formula

Kathleen Howarth

=IF([Transportation Type]@row ="Rental Car", "CWT Code Required”, IF([Transportation Type]@row=”Air”, "CWT Code Required" ,IF([Transportation Type]@row=”Train”, "CWT Code Required")))

Genevieve P.

Hi @kathleen howarth

Could you post a screen capture of the error, or outline what error you are receiving?

Just based on the text above, it looks like some of your quotation marks are straight, like this ", and some are curved, like this ”.

Smartsheet formulas would need all " marks to be the straight ones, like when you type into a cell in Smartsheet. Sometimes if you're copy/pasting formulas from other programs (such as a Mac Notepad) the characters used for quotation marks are actually seen as a different type of symbol and can cause an error.

Try replacing all your quotes with ones that were typed directly into Smartsheet!

Hope that helps,

Genevieve

Nick Burrus

I tested the code I pasted above, and it worked out flawlessly on my own Test Smartsheet.

Geneviere is correct, I didn't notice you use curly brackets. I rewrote the code from scratch. Did you copy the code I pasted or did you just add the last part?

A tip for the future: don't type your formulas in Microsoft Word

Nick Burrus

YOu are missing a closing statement.

=IF([Transportation Type]@row ="Rental Car", "CWT Code Required”, IF([Transportation Type]@row=”Air”, "CWT Code Required", IF([Transportation Type]@row=”Train”, "CWT Code Required", "Closing")))

Kathleen Howarth

Still gives me an error....

Genevieve P.

Hi @kathleen howarth

Could you post a screen capture of the error, or outline what error you are receiving?

Just based on the text above, it looks like some of your quotation marks are straight, like this ", and some are curved, like this ”.

Smartsheet formulas would need all " marks to be the straight ones, like when you type into a cell in Smartsheet. Sometimes if you're copy/pasting formulas from other programs (such as a Mac Notepad) the characters used for quotation marks are actually seen as a different type of symbol and can cause an error.

Try replacing all your quotes with ones that were typed directly into Smartsheet!

Hope that helps,

Genevieve

Nick Burrus

I tested the code I pasted above, and it worked out flawlessly on my own Test Smartsheet.

Geneviere is correct, I didn't notice you use curly brackets. I rewrote the code from scratch. Did you copy the code I pasted or did you just add the last part?

A tip for the future: don't type your formulas in Microsoft Word

Kathleen Howarth

I re-typed the quotes and it worked. Thanks all!

Genevieve P.

Glad you could get it working! 🙂