How can I collect a prior score based on 2 criteria?
We do 5S Audits of our building and I need to be able to pull the prior two scores of the same area. It worked for a while but then all of a sudden it started showing the Divide by Zero Error even though there are prior scores. Prior Score Formula:
We got the prior 5S Date to pull but for some reason, we can't pull the score. Prior Date Formula:
We have so many date columns due to indexes on other sheets/dashboards.
Can anyone see where I went wrong?
If anyone has any ideas for the "Last, Last" score that would super helpful as well!
Help Article Resources
Check out the Formula Handbook template!