Need to use the formula in Contact Cell
Dear,
I have a condition where i need to add a contact cell value by default based on other column value.
For EX:
When one row is submitted if the location enter is "ABC" then i need to choose contact cell(Project Manager) as A
If Location is "DEF" then choose contact cell as B.
Do we have any solution for this.
Best Answer
-
Hi @Jenishiya
If you want to use a name in the contact cell, I would create a Project Manager sheet like this.
Please note you can specify the contact's name using the "Add New" menu.
Then, you can reference the contact by using the INDEX and MATCH functions;
=IFERROR(INDEX({Project manager Range Manager}, MATCH(Location@row, {Project manager Range Location}, 0)), "")
You can check how the formula works by editing the published below.
You could use the "Assing someone" automation as shown below, but generally speaking, formulas are faster.
Answers
-
Hi @Jenishiya
If you want to use a name in the contact cell, I would create a Project Manager sheet like this.
Please note you can specify the contact's name using the "Add New" menu.
Then, you can reference the contact by using the INDEX and MATCH functions;
=IFERROR(INDEX({Project manager Range Manager}, MATCH(Location@row, {Project manager Range Location}, 0)), "")
You can check how the formula works by editing the published below.
You could use the "Assing someone" automation as shown below, but generally speaking, formulas are faster.
-
-
Happy to help!😁 @Jenishiya
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!