Duration and Date closed columns auto populate when Date initiated column is filled in
I have "Date Initiated", "Date Closed" and "Turnover Time" columns. The initiated and closed columns will (should) be populated when they happen, but the closed column auto populates to the same date as the date initiated column when it gets filled in.
I also had to create a "Predecessor" column which I hid because I don't need that info, but it was needed to have a formula/dependency to calculate the Turnover Time from the Initiated and Closed dates. I'm using the dependency feature instead of formula (Date Closed minus Date Initiated) because I want to count only 6 out of 7 days of the week (not counting Sundays).
How can I make it that the Date Closed and Turnover Time columns don't auto-populate?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65K Get Help
- 443 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 129 Brandfolder
- 150 Just for fun
- 70 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!