When submitting an automated weekly report that goes out on Monday, sometimes the whomever is submitting the document goes directly into the sheet and use the form from their or the sheet rather than using the form sent out on Mondays, and then this creates another row which messes up the formula that pulls the most updated entries onto a dashboard for executives.
Also, when we move some of the information from the updated column to another column labeled archive (due to what is being reported) it doesn't allow us to continuously move stuff into the column like it has a certain amount of characters it can only take.
Is there a workaround to fix these two issues?
