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
- 67.6K Get Help
- 472 Global Discussions
- 200 Use Cases
- 513 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!