Duration of a project
I have been calculating the duration of a project in the column excluding weekends and I have been using this simple formula
=NETWORKDAYS([Date Sent IKA/CHD]@row, [Date Closed]@row)
It has worked but if the project is on going and there is no entry in "date closed" column then it populates the column with an error message. Is there a way to use this formula with a "If" statement so that if there is a close date to use that and if not to use the current date to show the ongoing duration days?
Thanks
Best Answer
-
iferror(NETWORKDAYS([Date Sent IKA/CHD]@row, [Date Closed]@row),NETWORKDAYS([Date Sent IKA/CHD]@row,today())
Apologies I had an extra parenthesis stuck in there
Answers
-
=iferror(NETWORKDAYS([Date Sent IKA/CHD]@row, [Date Closed]@row)),NETWORKDAYS([Date Sent IKA/CHD]@row,today())
Like that?
-
@L@123 Unfortunately that formula did not work. I am not sure what part though I am still a novice to Smartsheet.
-
iferror(NETWORKDAYS([Date Sent IKA/CHD]@row, [Date Closed]@row),NETWORKDAYS([Date Sent IKA/CHD]@row,today())
Apologies I had an extra parenthesis stuck in there
-
@L@123 Thanks this worked!!
Help Article Resources
Categories
Check out the Formula Handbook template!