Combining 2 Formulas

Kyle Lewis
Kyle Lewis ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi, I am having trouble combining these 2 formulas:

=NETDAYS([Date Sent To Rep]@row, TODAY() - 1)

=IFERROR([Over Calc]@row, "")

Right now I have 2 separate columns calculating, but would like to have just 1. 

Is it possible to combine these 2 formulas? 

I want it to calculate the net days, but if there is not a date inputted i want the output to be a blank. 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!