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
Help Article Resources
Check out the Formula Handbook template!