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
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!