I was wondering if there was a way or some sort of function to pull the summary values of grouped items and find the average?
For example:
I have 10 groups of data separated out, each representing a Week and within that, I have a record for each day....
I want to write something that reads something like, “IF Number is less than 2100 but greater than 1600 than “Awesome”, IF number is less than 1600 than “Perfect””. I’m not sure how to so this…
I want to be able to have different icons display depending on the due date.
So far I have this, and it’s working well:
IF({Due Date} = BLANK(), BLANK(), IF({Due Date} = TODAY(), “ :red_circle: ”,IF(IS_BEFORE({Due Date},TODAY()), “ :alarm_clock: ”,IF...
I would love to know if it’s possible/be able to have a Single Select label changed based on an upcoming date.
So, for example, if I have a date column with 12/10 specified, I’d like the Single Select column to change from one option to “Due Soon” au...
