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?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!