Auto update a field with another field's data in the same record and table

Topic Labels: Data Formulas
245 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi there - 

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? 

Thank you!

Screenshot 2024-01-17 at 04.40.26.png

0 Replies 0