My Today Formula is coming up as #Unparseable ...
=SUMIFS(Mission:Mission, [RLO Receive Date]:[RLO Receive Date], ≥TODAY(-360))
Not sure what Im missing here? Anyone had any advice?
Ricky T
Gov Contractor for USSF
Answers
-
Are you using the ≥ symbol or separate greater than and equal symbols?
-
@Carson Penticuff I have tried it with both ≥ and ">="
I also tried with a COUNTIFS with no luck either
Ricky T
Gov Contractor for USSF
-
Im trying this too and getting #invalid operation
" =COUNTIFS(Mission:Mission, [RLO Receive Date]:[RLO Receive Date], TODAY(-365))"
Ricky T
Gov Contractor for USSF
-
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.
-
@Carson Penticuff Mission is my Primary Column so it has to stay as a TXT/ Number field :( RLO Receive Date is a date column.
Ricky T
Gov Contractor for USSF
-
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))
-
@Carson Penticuff So both of those formulas work, The mission names have dashes in them, you dont think thats creating the problem do you?
Ricky T
Gov Contractor for USSF
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!