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

Hey @gabe.apter! Just hopping in here to see if you were able to find a good solution for this! If not, shoot us a message at and we’d be happy to assist further with this! :blush: