Contacts Formula?

bkw1962 · 02/15/24

I have a sheet with 12K+ total tasks grouped in identical sequences of 15. I need to globally assign specific tasks in each group to specific contacts. I am aware through research that formulas cannot be used on contact columns. Is there a workaround anyone has discovered?

Thanks in advance.

SteyJ · 02/15/24

https://community.smartsheet.com/discussion/117582/contacts-formula

you should be able to nest if statements in the contact field assuming the contact is an email address

=IFERROR(IF([field]@row = "Criteria1", "bob@mbfcorp.net", IF([field]@row = "Criteria2", "john@mbfcorp.net")), "")

bkw1962 · 02/15/24

Thanks, Jacob, however, the column is of Contact List type, which does not appear to allow formulas. It is not a text type column, which would permit this approach.

Thanks again.

SteyJ · 02/15/24

https://community.smartsheet.com/discussion/comment/420136#Comment_420136

@bkw1962 I may be missing something here, but I was able to achieve this result while using a formula in a contact list column:

Here is the formula:

=IF([Primary Column]@row = "Task1", "bob@mdfcorp.net", 
IF([Primary Column]@row = "Task2", "john@mdfcorp.net", 
IF([Primary Column]@row = "Task3", "fred@mdfcorp.net")))

bkw1962 · 02/15/24

Is your Contact Column of type "text/number" or "Contact List"?

Contacts Formula?

Answers

Sincerely,

Sincerely,

Help Article Resources

Categories