Multiple Functions per Cell/Column


Is it possible for a single Cell/Column to have multiple functions and if so, how do you achieve it?

For reference, I am trying to track the amount of days between different date columns, however it might take a few hours/days to input the second date. Because of this the cell is filled with #Invalad Data Type.

Is there a way to combine =NETDAYS ([Ordered Date]@row, [Received Date]@row) *formula used to track the number of days* with =IFERROR(Ordered Date]@row - [Received Date]@row) *formula used to stop the #Invalad Data Type from showing*?

Any information would be helpful. Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!