My Today Formula is coming up as #Unparseable ...

RickyT

=SUMIFS(Mission:Mission, [RLO Receive Date]:[RLO Receive Date], ≥TODAY(-360))

Not sure what Im missing here? Anyone had any advice?

Carson Penticuff

Are you using the ≥ symbol or separate greater than and equal symbols?

RickyT

@Carson Penticuff I have tried it with both ≥  and ">="

I also tried with a COUNTIFS with no luck either

RickyT

Im trying this too and getting #invalid operation

" =COUNTIFS(Mission:Mission, [RLO Receive Date]:[RLO Receive Date], TODAY(-365))"

Carson Penticuff

It should work with ">=", at least syntactically. You may want to verify that [Mission] is formatted as INT and not text, especially if that column is populated with a formula. Also that [RLO Receive Date] is formatted as DATE.

RickyT

@Carson Penticuff Mission is my Primary Column so it has to stay as a TXT/ Number field :( RLO Receive Date is a date column.

Carson Penticuff

You could try these to verify formatting. Even with the correct column formatting, certain individual cells can be different, especially if they are populated with a formula with data pulled in from another location.

=COUNTIFS(Mission:Mission, ISNUMBER(@cell))

=COUNTIFS([RLO Receive Date]:[RLO Receive Date], ISDATE(@cell))

RickyT

@Carson Penticuff So both of those formulas work, The mission names have dashes in them, you dont think thats creating the problem do you?

Carson Penticuff

Hmm... maybe we need to backup for a moment. If you have dashes in the Mission column, you must not be attempting to do what I thought you wanted. With the original formula, you would be summing the values of the Mission column. Can you describe what you are trying to return from the formula?