Can I set up an alert for when a specific sum is reached in my sheet?
rapach
✭✭
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.
Answers
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives