Formulas to determine date
Part 1: Form - I have a form built to document monthly inspection results. Since I need to report results for each month on a scorecard, I have a question asking if the inspection is for the current month or the previous month. If current, they are asked for the inspection date. If, previous month, they are asked for the month of the inspection they are documenting. I built it like this in case they are documenting inspection results after the month's end - for example, documenting January's results in February.
Part 2: Form Data Sheet - I have set up helper columns to convert "January" to a month # and a parsed year based on the submission date.
I am looking for a way to come up with a "final walk-through date" to use for the monthly metrics. by pulling in "Date 1" if the inspection was for a previous date and pulling "Date 2" if they documented the current month inspection date.
Below is a screenshot of the data sheet. Thanks for reviewing!
Help Article Resources
Check out the Formula Handbook template!