Thanks for the input. I’m relatively new, so I’m open to suggestions…there’s likely a better way to do what I’m trying to do.
So status A column is like new request, approved, in process, need attention, done, etc. The other status column (B) is a type of change request like new account, pilot to routine account, account item increase, etc. Depending on the TYPE of change request, different teams need to be notified. So when status A is approved, depending on status B (TYPE of change) the applicable team needs notified…like maybe status A is approved and status B is new account a sales team will get notified, but if it is status A approved and status B is account item increase a customer support team will get notified.
Does that help/make sense?