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.
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.
Hello, I am currently attempting to organize my files in Workspace by creating folders to group them. I am doing this by dragging and dropping sheets from the 'Sheets' folder into my 'Workspace' folder. However, some sheets that I own and created do not appear in the 'Sheets' folder. I even tried editing some details in my…
The number of Unlicensed Users was listed previously under User Accounts. Why is it no longer there?
I have a filter set so that if this task complete box is checked, then the row is hidden. Is there a way to make it so that if the parent row is checked, then the child rows hide as well? Right now when a parent row is checked, only the parent row is hidden.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.