Here is my formula
IF({Dept} =Bath, “8.5”, IF({Dept} =Win, “10”, IF({Dept} =ODL, “0” ) ) )
My objective - if field “Dept” is Bath then 8.5, if it is Win then 10, if it is ODL then 0
What am I doing wrong?
+3
+29Welcome to the Airtable Community!
You need to put quotes around your text strings and not the numbers. You can also use SWITCH instead of nested IFs.
SWITCH( {Dept},
"Bath", 8.5,
"Win", 10,
"ODL", 0
)
+3Welcome to the Airtable Community!
You need to put quotes around your text strings and not the numbers. You can also use SWITCH instead of nested IFs.
SWITCH( {Dept},
"Bath", 8.5,
"Win", 10,
"ODL", 0
)
I apologize - this is probably a dumb question… do I need to take spaces out. If I copy and paste I get an error.
+29I apologize - this is probably a dumb question… do I need to take spaces out. If I copy and paste I get an error.
Looks like some curly quotes snuck in when I was typing on my phone. I straightened them. You can try copy/pasting again.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.