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!