I have three different formulas, containing various criteria, which I want to want to marry together and for which all things must be true: 1) project start date is less than 1/1/24; 2) go-live date i…
Hello! We are trying to create a workflow that would include resending the Approval request X # days after the original Approval Request was sent but not yet answered. We're aware of reminders and upd…
I am trying to solve for a formula to countifs all conditions, except for one that I want to count if either/or: =COUNTIFS({HR Projects - Project Stage}, Metrics16, {HR Projects - PMO Must-Do}, 1, {Ra…
I have the "base" formula correct and working but can't figure out how to string it together (are there best practices in this area?) with a larger formula: This piece works: =IF(OR([Go Live Month]@ro…