Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula Help Error Message NETWORKDAYS

Carol Bokas
edited 12/09/19 in Archived 2015 Posts

New user of SmartSheet and not too adept at Excel. I am trying to make a formula IF/AND so that there is no error message in a cell that uses the NETWORKDAYS functions if there are not dates in the two source columns. E.g., Job Complete-Est and Job Complete-Actual only have a date in neither or one 

So, if there is not a date in either, the cell with the variance will be blank rather than #Missing or invalid parameters


This discussion has been closed.