Duration of a project

Stephanie Foster

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

L_123

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

=iferror(NETWORKDAYS([Date Sent IKA/CHD]@row, [Date Closed]@row)),NETWORKDAYS([Date Sent IKA/CHD]@row,today())

Like that?

Stephanie Foster

@L@123 Unfortunately that formula did not work. I am not sure what part though I am still a novice to Smartsheet.

L_123

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

Stephanie Foster

@L@123 Thanks this worked!!