My Scenario is: I have an "All Jobs" table in which, for each client there are multiple jobs. The column "Visit Schedule date" in the "all jobs" table has the value for each job to be done. The service period and the no of jobs are defined in the "Clients" table with the columns, "First date", "End date" and "No of visits".
On updating any "visit schedule date", in " Al Jobs", the values in the same column of the subsequent rows should automatically adjusted with new dates. How it can be done in the app sheet?
LinkedIn
Twitter
