Need to use the formula in Contact Cell

Jenishiya

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.

jmyzk_cloudsmart_jp

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.

https://app.smartsheet.com/b/publish?EQBCT=a5dd71c0f9584d47ba57fe3de44d26b0

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.

https://app.smartsheet.com/b/publish?EQBCT=6d10580d3f6946fcad571d3039b91bf4

You could use the "Assing someone" automation as shown below, but generally speaking, formulas are faster.

jmyzk_cloudsmart_jp

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.

https://app.smartsheet.com/b/publish?EQBCT=a5dd71c0f9584d47ba57fe3de44d26b0

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.

https://app.smartsheet.com/b/publish?EQBCT=6d10580d3f6946fcad571d3039b91bf4

You could use the "Assing someone" automation as shown below, but generally speaking, formulas are faster.

Jenishiya

@jmyzk_cloudsmart_jp

Thanks for the answer and detailed steps.

This works.

jmyzk_cloudsmart_jp

Happy to help!😁 @Jenishiya