I have a GoggleSheet table and uses, through the App, update the Data. The data is updated as “Copy old and add”, so it leaves the old data and adds new data point. Uses does this 4 times a month.
So now for March 2020, I have 4 data points for 4 different days
So far so good.
I would like to fill in the data for the days that user does not input data with previous days data. Eg: User entered data for 03/01/2020 and 03/07/2020. I would like to auto fill data for 03/02/2020 with data as 03/01/2020, until we see a new entry on Date, which happens to be 03/07/2020 in this case. Then for 03/08/2020, follow the same logic until we see the next change in Date.
Columns that change when user saves the data
I know this is long. Please ask questions for more details, please
I really appreciate the help.
Special Kudos to person solving this!