how does the formula work for duration column when predecessor activated
I am getting a #invalide data type in some but not all rows.
Answers
-
Can you share the formula that you are using for duration? Or is it the system Gantt column?
If it is the system column, it should get automatically updated. Can you share a screenshot of the project settings?
-
@Anupriya I am using the system column below is the screen shot you requested, thank you for taking time.
-
The only reason that I can think of is a wrong date format. Other than that it should work fine.
-
I've seen this happen before when there's a column with a Formula before Project Settings and dependencies were applied. Then if you enable Dependencies, the column that had the formula (which previously had an error) will still show that error.
Try adding a "New Duration" column to your sheet, then adjust your Duration column in your settings to look at the new column that never had a formula.
Once you have Duration in the New column, delete out this old one.
Let me know if this fixes your issue!
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!