If formula looking at 2 different columns
Hello I am trying to write a formula that looks at two different columns on my Smartsheet and returns a value based on what is in the cells.
I want to look at ticket location column and if value is "Complete" I want to return value "Implemented"
Second I want to look at Fix Version Column and if it is blank return "Backlog", if there is a value in the cell then I want to return "Scheduled"
I have tried this formula in multiple ways but keep getting either unparseable or invalid errors.
Below are two examples of what I have tried so far:
=IF([Ticket Location]@row = "Completed", "Implemented"), IF([Fix Version (Vijay)]@row = "", "Backlog", "Scheduled")))
=IF(OR([Ticket Location]@row = "Completed"), "Implemented", IF(OR(ISBLANK([Fix Version (Vijay)]@row), "Scheduled", "Backlog"))))
The formulas that I got to work individually are:
=IF(OR([Ticket Location]@row = "Completed"), "Implemented")
=IF([Fix Version (Vijay)]@row = "", "Backlog", "Scheduled")
=IF(NOT(ISBLANK([Fix Version (Vijay)]@row)), "Scheduled", "Backlog")
Help!
Best Answer

=IF([Ticket Location]@row = "Completed", "Implemented", IF([Fix Version (Vijay)]@row = "", "Backlog", "Scheduled"))
Answers

=IF([Ticket Location]@row = "Completed", "Implemented", IF([Fix Version (Vijay)]@row = "", "Backlog", "Scheduled"))

@Paul H thank you so much! Just what I needed.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!