Cell adjustment to keep track of data
I have created sheet where my colleagues fill with a form and gather updates on a daily basis. With the help of a URL it made the filling of the for easier, yet we are loosing data as if the form tabs are not exactly populated according to the URL the data doesn't enter back in the sheet.
I am trying to find a solution for this and the only way I found is to compare entries with the same Job# and take the last 2 created entries and fill the row with the needed dates if blank, yet I am not able to write the formulas for it.
If someone could help it will be much appreciated.