Time Formula
Options
Answers
-
Hi @ericncarr, No not yet. It has been a crazy few weeks.
-
I'd just change the formula to use NETWORKDAYS, I think you want to add the -1 so it doesn't count the existing day but I haven't looked at this in a while so you'd want to play with it.
=IF(NETWORKDAYS([CD Date]@row, [RD Date]@row) - 1 < 2, "Yes", IF(AND(NETWORKDAYS([CD Date]@row, [RD Date]@row) - 1, [CD 24hr Dec]@row <= [RD 24hr Dec]@row), "Yes", "No"))
-
Hi@ericncarr,
I tried updating and playing with it but the column would now update to always met sla. I added you to my sheet to see if I am missing something.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!