Formulas for + Days Date with Multiple Conditions and Date Countdown

I need some help creating a couple of formulas for + Days Date based on a couple of conditions and Date Countdown as would be greatly appreciated:

 

  1. In the SLA Due Date column if the SMCC Action column (has 2 drop down selections of NIR & LI) is NIR to populate a date + 45 days and if LI is selected to populate a date + 7 days  
  2. In the Number of Days SLA Due column a date countdown formula to show the Netdays between the SLA Due Date column and the Date Submitted to DC and counts down the remaining days until a date is entered into the Actual Date Request Completed <DC Action> column and the countdown stops so we know many days were remaining upon completion.   

@Paul Newcome

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!