-
Total Count for Specific Date Range from another Sheet
I am referencing a seperate SmartSheet that I have Admin rights on. I want to count the number of items listed within each specific date range was work by. I would like to then find out how many of those items have been completed. I have been trying to work with the following formula but it keeps bring back "0".…
-
Can the Sys Admin view the overall user activity in Center of Excellence for the assigned account?
As part of the Smartsheet roll out at our company, we 'assigned' our paid license employees several Center of Excellence Training Modules/Courses with different dates to get them completed. I am the Sys Admin and trying to verify who has completed their modules and who has not. Do I as the Sys Admin have access to view all…
-
Formula to auto calculate time difference in hours between two 24hr format times?
I'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format. Once picking their starting time and end time, I would like the third column, "Total Hours", to…
-
Trying to count multiple people in a cell
I have a column set as Contact List and the Allow Multiple Contacts per Cell field is checked. I am using COUNTIF statements to count how many people are assigned to the tasks for a dashboard. I am using the formula: =COUNTIF({Project List Range 3}, Assigned1) Where Project List Range 3 is the Column in my master sheet…
-
Re: Task Alerts
I am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up To do this I use a form to add new tasks and then included the following columns in my sheet so; * a date column for when activity is due…
-
Feedback Request on Some Long-Term Reliability Related Issues
Hi I am planning to build a full-scale Human-Resource Management app in Smartsheet which will be used by approx 300 employees. I am fully aware of its functionality, storage-limits, workflows, etc., and I'm okay with all that. My only question: Is smartsheet really so secure / reliable that I can take this bold step with…
-
Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View
Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be training in any product line. The individual product lines are listed in the primary…
-
What happens when I reach my 5000th row?
May I know if there will be any alert when a sheet is reaching it's 5000th row? My team is working on my sheet as free collaborators, can I be alerted when the sheet is reaching the maximum capacity? Thanks.
-
Update field in another sheet
Hi there, i'm trying to figure this out: I have sheet #1 with an email address field. When that field is updated, Smartsheet automatically updates sheet #2 email address field with the email entered in sheet #1. Is this possible?
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…