How can I collect a prior score based on 2 criteria?

Options

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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!