Contacts Formula?

bkw1962

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

Contacts Formula?

bkw1962

Feb 15, 2024

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.

---

View Post

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

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

bkw1962

Feb 15, 2024

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.

@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

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