Date Calculation - Invalid Operation error
Answers
-
Hello, Could anyone please help me here. I need the calculation results has to show as particular a Date. Which specifies the Due date of the payment. (The formula which I have used is "Miro date(Date of invoice booked) + 30 (Credit Days what i 'm enjoying at present) - 2(Ahead of 2 days)).
But unfortunately the result of this evaluation look like- "#Invalid Operation".
Could anyone please guide what is this error and how can i overcome this.
Thanks in advance
Manuel
-
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Paul Newcome @Genevieve P - Good Day, Sorry to say that still, it's not working for me. I have already changed the Miro date column as the date type column. But Still the error is coming.
Hope you are clear with my question. (Suppose the Miro date is 03/05/2021. And I have 15 days credit. I would like pay before 2 days of my due date. So finally the due date has to show as - 16/05/2021. (03/05/2021+15-2). Will this work in smartsheet. Still I'm getting error- #Invalid coumn value.
Please advise.
-
What type of column is your Due Date column? This will also need to be a Date Column to house the returned value as a date. (See: #INVALID COLUMN VALUE Error)
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
You will also want to make sure that the column you are putting the formula into is a date type column.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Genevieve P - Perfect. It's worked. Thanks.
-
@Paul Newcome - Thanks. It's worked.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!