I've set up a table that I want to use to 'score' certain projects by quarter. I.e. at the end of Q1, Project 1 received a 50 score, Project 2 received an 80 score, Project 3 received a 100 score, so on and so forth.
Currently in my table, the projects are separate records, and I have four columns - Latest Score, Q1 Score, Q2 Score, Q3 Score, and Q4 Score. They are all number fields. I've inserted a photo below.
Is there a formula that would enable the Latest Score field to automatically reflect the current quarter we were in without me having to update it manually?