3

In the workflow settings, in the start options, you could select the option “Start workflow automatically when an item is changed.”. It will trigger workflow when the item is updated.


2

The FIND function is not real friendly… if there is not a match it returns an error. Here's one solution: =IF( NOT(ISERR(FIND("Andrews",[Tracking Number]))), "ANDREWS", IF( NOT(ISERR(FIND("Bolling",[Tracking Number]))), "BOLLING", IF( NOT(ISERR(FIND("Pentagon",[Tracking Number]))), "PENTAGON", "none" ))) Here's an alternate solution: =IF( ...


2

Since you will send different emails, I think you should use 7 if condition by using OOB workflow actions as below: If you don’t want to use Else, you can all if condition to "Parallel Block" as below:


1

You can do it similar to that in Excel :) You can checkout the below sample to get an idea: "background-color": "= if([$OtherColumn] == 'Red', 'red', if([$OtherColumn] == 'Green', 'green', if([$OtherColumn] == 'Amber', 'amber', if([$OtherColumn] == 'Gray', 'gray', 'blue'))))"


Only top voted, non community-wiki answers of a minimum length are eligible