IF formula help please

I have this formula that is working perfectly, it returns the value in number of days between

  1. Date submitted to Todays date OR
  2. Date submitted to Date Comments Log Received

=IFERROR(IF([Comments Log Received]@row = "", NETDAYS([Date Submitted to SJTA]@row, TODAY()), NETDAYS([Date Submitted to SJTA]@row, [Comments Log Received]@row)), "")

However, I want to add another IF calculation to that formula to return the value of number of days between Date submitted and Document Status Date. This is what I thought that would look like, but I keep getting an error message. #INCORRECT ARGUMENT SET

=IFERROR(IF([Comments Log Received]@row = "", NETDAYS([Date Submitted to SJTA]@row, TODAY()), NETDAYS([Date Submitted to SJTA]@row, [Comments Log Received]@row), NETDAYS([Date Submitted to SJTA]@row, [SJTA Document Status Date]@row)), "")


What am I doing wrong? Please help.

Thanks.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!