If have a scripted function called Google_Duration which brings back the travel time between two addresses depending on the travel mode on file for the tutor.
Also have formulae that look like this in over 200 columns that I don’t want to spend time duplicating or working out the glide logic. My copy formulas down script handles the need well when adding a new row.
=if(LB43=“X”,“X”,if(OR(AND($BJ43=“Y”,DG$1>=$BK43,DG$1<$BL43),AND($BJ43=“Y”,DG$1>=$BM43,DG$1<$BN43),AND($BJ43=“Y”,DG$1>=$BO43,DG$1<$BP43)),“A”,“U”))