Dynamic Date Calculations

We have different project types, and each project type has a different number of days is needed to complete a task. We have a sheet of about 30 rows that defines based on what project type, how many days it takes to complete the task. I want to make a date column to say "this is when this task is due" but I'm not sure if it's possible. I'd like my formula to be
[Installation Date]@row - [Days to Complete]@row
But I'm getting an error because the Installation Date is a date type column and the days to complete is a number/text field. Does anyone know how I can achieve this measurement?
Answers
-
Hello @torishriver
Your formula should work if you're adding or subtracting days from a date column even if the "Day to Complete" us a number/text column.
Can you share what error are you getting and share a screenshot of your sheet with the formula if possible?
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!