IF and ISDATE Formula

✭✭✭✭

I want to calculate NETDAYS from Submission Date to Todays Date, or to Comments Log Received Date

I have this formula that works.

However, I need to expand the formula to calculate what happens after the Comments Log Received becomes a date. This is what I came up with, but it does not work.

What am I doing wrong?

Tags:

• ✭✭✭✭

Hello SJTA,

I can tell you are having some trouble with your IF Statements, it turns out the ISDate function is giving you grief.

I am happy to provide a solution. Please try:

As if to say:

Then return the number of days between Submitted to SJTA and today.

Else return the number of days between the date submitted to SJTA and Comments Log Received

If formula returns an error and Comments Log Received contains a date

Then return the number of days between the Date Submitted to SJTA and SJTA Approval Date

If formula returns an error and Comments Log Received does not contain a date

Then return blank.

Ward Hively

President and Chief Consultant

🌉Skyway Consulting Co.🌉

Need Smartsheet Help? Schedule a complementary consultation click SCHEDULE

Does your Dashboard need a map that updates from Smartsheet Data? We pioneered 101+ ways to add a map to a Smartsheet Dashboard.

Website: https://skywayconsultingco.com

• ✭✭✭✭

Thanks but, this does not work. The first half of the formula works, however the IF ISDATE does not change the value.

• ✭✭✭✭

I responded more thoroughly on LinkedIn but, this should work!!!

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

Ward Hively

President and Chief Consultant

🌉Skyway Consulting Co.🌉

Need Smartsheet Help? Schedule a complementary consultation click SCHEDULE

Does your Dashboard need a map that updates from Smartsheet Data? We pioneered 101+ ways to add a map to a Smartsheet Dashboard.

Website: https://skywayconsultingco.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!