Hi everyone,

I've searched through the community but couldn't find the right solution.

I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information on the 15th of each month, so the formula would need to cover


Hello All, 

I am trying to automate the blue ball based on complete and the red, yellow and green based on date. I have come up with the following formula but I am getting an UNPARSE any help would be great.

=If(Status1 =Complete, "Blue", IF(OR(ISBLANK([End Date]1), [End Date]1 >= Today(-5)), "Red",



I'm trying to add amounts together from different sheets based on certain criteria. I have my data divided up across multiple sheets because it is more than 500 rows. Is this possible? If so, how do I do this?

My formula for a single sheet is: =SUMIFS({Dollar amount}, {Worksheet Range 1},


Hi all,

I am trying to find a formula to count the number of times a time appears that is over 30 minutes. The times are all listed in Column 21 in the following format:

0:15, 0:27, 0:13, 0:20

I have tried using variations of the below formula but I get error messages.