Hello,
Can anyone confirm if there is a maximum number of email addresses that can be added as contacts to a particular sheet using automations? I believe that number is 101 addresses.
My sheet features multiple approval workflows. Each workflow can have multiple approvers, for which column formulas are used to AND each approver. For each row, the identity of the approvers are dependent on cell values (essentially, which project the row refers to). I have about two or three dozen automations that assign an email address to a particular column based on field values.
In addition to the workflow approvals, this sheet also tracks task work. So there are two additional contact columns — one for the task requestor email address and one for the employee assigned to the task.
As I am creating my automations, I eventually hit the following error message when trying to save:
"Sorry, we're having trouble reaching Smartsheet right now. Please check for any known issues at status.smartsheet.com or contact us at www.smartsheet.com/gethelp for help."
Doing some troubleshooting, I see that this happens once I add the 102nd email address to the sheet, either by manual input into a cell, or by adding it in the Assign People box in an automation. It also appears that maybe if a contact is deleted from the sheet, that deleted email address still counts to that ~100 max addresses?
Can anyone confirm that this is the case?
If so, I'm not sure how to proceed. With employee role turnover, this limit should eventually be exceeded. Does anyone have suggestions of how to rearchitect this situation?
