Stumped by a formula!


I cant figure out why this formula isn't working and am hoping someone can help me.

I have a discipline column, a current date column and a in service required column.

based on the time of year and discipline selected, a certain number of in-service hours is required.

I.E. from January 1st to April 1st = 6 (hours) , from April 1st to October 1st = 3 (hours) only if PCA is selected.

The first part of the formula works (if the date is before April 1st the number 6 appears in the in-service column. however, if I select a date past April 1st it stays blank.

(disregard the 6 column names to the right)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!