Human Resources
Discussion List
-
Vlookup Limitation?In Formulas and FunctionsHi I would like to understand about this limitation in vlookup: * Each sheet can include no more than 100 distinct cross-sheet references. * There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet …
-
FIRST OF THE MONTH AFTER 60 DAYSIn Formulas and FunctionsI am trying to auto populate effective dates for benefits and I cannot get the calculation to work past the first part (60 days after start date) I need to have the following result as an example Start date: 1/15/2020 Effective Date:…
-
Total Count for Specific Date Range from another SheetIn Formulas and FunctionsI 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…
-
Can the Sys Admin view the overall user activity in Center of Excellence for the assigned account?In Using SmartsheetAs 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…
-
Formula to auto calculate time difference in hours between two 24hr format times?In Formulas and FunctionsI'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.…
-
Trying to count multiple people in a cellIn Formulas and FunctionsI 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 L…
-
Re: Task AlertsIn Archived 2017 PostsI 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 inc…
-
Feedback Request on Some Long-Term Reliability Related IssuesIn Using SmartsheetHi 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 …
-
Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master ViewIn Formulas and FunctionsHello, 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 tr…
-
What happens when I reach my 5000th row?In Using SmartsheetMay 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.