#Invalid Operation when determining whether date is in the past
I am working on answering someone else's question, and have come across an issue. I am perplexed! Can you please help me?
The formula is to determine whether the planned end date is in the past. If it is, it's to show "Overdue"; if it's not, it's to show "Current." (There will be much more to this formula later, but I'm just trying to get this portion to work.)
Here's the formula:
I keep getting an #INVALID OPERATION. What am I doing wrong?!?
Best Answer
-
Is Planned End a date column?
are there any errors on that column (even on other rows...)?
Answers
-
Is Planned End a date column?
are there any errors on that column (even on other rows...)?
-
Eureka! Problem solved. Thank you so much! I thought I had set it to date, but apparently not. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!