Carry formula-email value through all records of same table

  • 0
  • 1
  • Question
  • Updated 1 year ago
Our company has a revolving team management system.  I have a table of Resources in which I indicate the current Team Administration.  I would like the email to carry to all records in the Resources table.  The reason is that within the company there are two teams (and resources can bounce between Team 1 and Team 2), hence two sets of Team Administrators and the formula-email field.  I don't want to hard code this since the Team Administrators rotates out, and I use a formula-email field to set who the new group is.  I just select which team the resource is on and they see the current Team Administration (which I set by selecting a value in a drop down field when the administration changes).
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1

Be the first to post a reply!