I cannot convert my if statement to a column formula
karimo6
✭✭
I have an if statement referencing another column named "Country" - I want to define this if statement into a Column Formula but it says "the column formula syntax isn't quite right". This is my IF statement.
=IF(Country1 = "US", "01-440-0187 (US)", IF(Country1 = "Canada", "01-440-0188 (CA)", IF(Country1 = "Mexico", "01-440-0189 (MX)")))
Answers
-
Try this: =IF(Country1@row = "US", "01-440-0187 (US)", IF(Country1@row = "Canada", "01-440-0188 (CA)", IF(Country1@row = "Mexico", "01-440-0189 (MX)", "")))
Hope this helps,
Dave
-
For some reason it turns my IF statement unperishable.
-
got it Dave, just needed to delete the 1 in between the @rows. Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives