Update a sheet based on changes in another sheet

PeteM_1972

Hi all,

I have successfully created a system for recording and tracking engineers call outs for our small family business. We use workflow to move the jobs through the various sheets (stages) of the process. All good.

Now though, a new request has come to me and I'm damned if I can work out how to do it.

Any thought very much appreciated.

The logic steps look this this:

——————————————————————————From: Sheet “A"

When a Row is added or updated, select “AA” if “Type contains Service” and “Client is BB” and “Service = Null”

Then: Update Sheet “Service Schedule”

1. Add 365 days to Next Service Date
2. Change last service date to same as Tech Report “Created Date”

Then: Update Sheet “A”  “Service = Done”

END

——————————————————————————

Thanks in advance

Pete..

Paul Newcome

Are you able to provide screenshots fo rcontext?