Can I set up an alert for when a specific sum is reached in my sheet?

I am creating a sheet to track PTO. I want to set up an alert when a new day of PTO makes the sum of the total sheet reach a certain number. For example, the allotted PTO day is 15. I want to get an alert when that sum reaches 10.


  • Cleversheet
    Cleversheet ✭✭✭✭✭✭

    You'll need a column that accumulates the PTO for each person*, along with a checkbox column that is automatically checked when its formula determines that the value in the [YTD PTO] column is equal to or greater than 10. When that box is checked it will trigger your alert message.

    * - This assumes you have a staff list in one sheet that uses a SUMIFS formula in its [YTD PTO] column to accumulate the approved PTO requests found in another sheet.