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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!