I need to calculate the estimated end date of a project based on working days
To calculate the end date of my project, I need a formula that would take today's date and add the number of working days left to it. I keep getting an Invalid data type error.
The Today's Date column and my Estimated project finish date column are both set as Date column types. My Days Left column has it's own formula based on the number of employees assigned to the project and the average time it takes to complete parts of the project (so the '92' will change based on these factors). What am I doing wrong that my finish date keeps giving me an error? Thanks.
Best Answer
-
Hey @beckyw,
That seems like it should work! Invalid Data Type errors usually means that the data being passed is the wrong type. If the Today's Date column is a Date column, then maybe there's an issue with the Days Left column? Try wrapping the [Days Left]@row in an INT() function to make sure it's converted to a number:
=WORKDAY([Today's Date]1, INT([Days Left]@row))
Hope this helps!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
Answers
-
Hey @beckyw,
That seems like it should work! Invalid Data Type errors usually means that the data being passed is the wrong type. If the Today's Date column is a Date column, then maybe there's an issue with the Days Left column? Try wrapping the [Days Left]@row in an INT() function to make sure it's converted to a number:
=WORKDAY([Today's Date]1, INT([Days Left]@row))
Hope this helps!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
Thanks, @bisaacs ! It worked when adding INT.
And thank you for answering so quickly!
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!