How can I get a list of collaborators with editor access?



I want to send an update reminder to people who have access to a sheet but only to those with editor access.

There is a workflow to send reminders to "everyone shared to this sheet" but I only want to send it to those that will be able to edit (exclude viewers).

Is there a way to get the list of editors shared to the sheet via a formula or any workaround?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!