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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!