Greater than/Less than dates AND confusion

I need to calculate a number based on if a date is greater than or less than dates AND based on a selection in another column.

example: If current date is between january-july from current year AND discipline dropdown is HHA then return number 6 in hours required and if the dropdown is PCA return 3.

Discipline column has two dropdowns: HHA, PCA

Current Date column

hours required

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!