Comparing Quarter value/number to another value based on the quarter I'm in

Dear community,

I’m trying to figure out a solution to support our need:

we have a board, with Items and the following columns:
Item name, current (numeric value), Q1 Goal (numeric value), Q2 Goal (numeric value), etc (same with all other Qs).
I would like to be able to compare Quarter goal value/number to another column value (current) based on the quarter I’m in.
for example, if based on the todays date I’m in Q2, and the Q2 goal is 1 , and the current value is 0.8, I would like to automatically update the status column with a value