Formula for auto populate?
In the REP field, every rep is assigned to an area. Would there be a formula that if I choose SALES REP 1 it will auto-populate on the state field AREA 3? Thanks
Answers
-
@cxfl2020 please elaborate you want to choose Sales REP 1 on a second sheet and have Area 3 automatically populated on the second sheet
Parul Mishra
-
It looks like you have "Rep 1" listed for two different areas. Would you want both of those areas pulled in if you enter "Rep 1" on the other sheet, or would you want it to only pull one of them. If you only want it to pull one of them, how would you determine which one to pull?
-
I have a list of reps and all reps are assigned to an area. Now what I want to happen is if I type the name of the sales rep (Column A) it will auto-populate the area (Column B). My goal is not to type their area.
-
to be clear there are 48 sales rep and 7 areas.
-
Hi @cxfl2020 Taking this as reference
You can try something like this
=JOIN(COLLECT({State}, {REP}, [Primary column]@row, 0), " ")
As soon as you type SalesRep1 in your Primary Column it will fetch Area 1 and Area 2 value in your column 2
Parul Mishra
-
Right. That's why I asked how you wanted it to work if you have the same sales rep listed for multiple areas such as how you have it in your screenshot. If you want to pull all areas in, then you will need a JOIN/COLLECT, but if you wanted to only pull one area in then we would need to establish some logic to determine which one.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!