Autopopulate text based on drop down option
Hello!
I'm trying to figure out a formula to autopopulate text in a cell based on a drop down option in a previous cell. Basically one column would contain the drop down (Campus) and based on which campus is selected, a different cell (account) would autopopulate.
Ideally it would look like this:
Campus (drop down) Account (auto pop)
Blue 1234
Red 4568
Blue 1234
In looking through the forum, I saw this formula but would need to tweak it a bit in order for it to "hopefully" work: =IF(AND([Cancellation Effective]@row <> "", [Cancellation Effective]@row <= TODAY()), "Inactive", IF([Start Date for Phase 1]@row <= TODAY(), "Active", IF([Start Date for Phase 1]@row >= TODAY(), "Onboarding")))
Any insights would be super helpful!
Best Answer

That was my fault. I missed a quotation mark. Try this...
=IF(Campus@row = "Blue", "123412", IF(Campus@row = "Red", "456812", IF(Campus@row = "Green", "745612")))
Answers

As and update I've tried to play around with the formula and use the IF(AND), but am still getting nowwhere...
=IF(AND([Campus Name]2 = "Blue", "123412", IF(AND([Campus Name]2 = "Red", "456812", IF(AND([Campus Name]2 = "Green", "745612"))))))
I got it to work with just one IF condition, but can't seem to move forward with multiple nested rules.
I'm getting the message "INCORRECT ARGUMENT SET" :(

Try something like this...
=IF(Campus@row = "Blue", "123412", IF(Campus@row = "Red", 456812", IF(Campus@row = "Green", "745612")))

Hi Paul,
Unfortunately with that formula I get "UNPARSEABLE"
Any other thoughts?
I did get this one to work:
=IF(AND([Campus Name]2 = "Blue", "123412", IF(AND([Campus Name]2 = "Red", "456812", IF(AND([Campus Name]2 = "Green", "745612"))))))
but only on "Blue"...for the columns with "Red" or "Green" it came up as #INCORRECT ARGUMENT SET

That was my fault. I missed a quotation mark. Try this...
=IF(Campus@row = "Blue", "123412", IF(Campus@row = "Red", "456812", IF(Campus@row = "Green", "745612")))

Paul, you're a frickin genius!!!
Thank you sooooo much. This is amazing. You are amazing.

Happy to help. 👍️
Sorry about the initial quotation mark issue.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 416 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!