Duration formula
Hi there,
I have tried reaching out to Smartsheet for help and received nothing so hopping on here as a desperate last attempt.
I have a column with a start date and another column with a finish date. I am trying to get the following column to calculate the days between the start and finish dates. Can someone please give me a formula to do this?
I have tried
=networkday([start]1,[finish]1)
and the formula lights up like it is working but then will say #invalid and I don't understand.
Answers
-
Possible issue: if the start and finish date columns are not checked as DATE in their properties, then you would get an invalid error. To check, right click the column header, select Edit Column Properties, then select Date.
If this is a big sheet and you are populating large columns, consider using the @row instead:
=networkday([start]@row,[finish]@row)
After you've tabbed out of the cell (and you've checked the formula is working appropriately), right click the cell with the formula and select "Make Column Formula". Column formulas only work with @row entries--you can not reference specific rows as your original formula does.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!