-
MM/DD/YYYY Date Format
Can we please add a MM/DD/YYYY date format to Smartsheet? I would like to feed this date into some DocuSign forms I need employees to complete, but they require a MM/DD/YYYY format in order for me to be able to utilize these dates.
-
Does anyone have a solution for tracking occupational health information?
I'm looking for a solution to use forms for collecting employees' vaccinations and other occupational health requirements for employment. Different from the current templates that help track pandemic items. We need to be able to send a form during employee onboarding to request that the candidate submits their vaccination…
-
INVALID DATA TYPE Error in single cell of column formula
Hello, I am getting one cell returning the "INVALID DATA TYPE" error in a column formula. I have 159 rows in this sheet, and only one cell has the error, so I am very confused. The formulas is: =COUNTIFS({Site Visits Range 1}, Type@row, {Site Visits Range 3}, [Primary Column]@row, {Site Visits Range 2}, <>"", {Site Visits…
-
Trying to use Time Function to calculate how many days,hours,minutes
I am using this found in the functions list: But Error says #INVALID DATA TYPE. Is that because the columns i am referencing are cross reference formulas and not text/number types? SEE BELOW FORMULA AND SHEET: =DATEONLY([Pending Tech Response Date/Time Stamp]@row) - DATEONLY([Completed Date/Time Stamp]@row) + " day(s), " +…
-
How do I add age range
I am trying to take a list of all employees that includes their info like department, name, and age and then create a age range (like 16-24, 25-34, etc...) so I can then count how many employees fall under each age range. I have tried two ways and neither work. FIRST ATTEMPT: -The first and i think easiest is to have a…
-
9-box talent assessment
I have googled and cannot find any company that has automated the 9-box talent assessment outside of excel. I feel like this is a huge miss as all large corporations do talent reviews and succession planning. What would be really cool is if you had all your HR data in Smartsheet and you could have a visual of each team on…
-
Viewing team capacity over time
I am trying to see my team's capacity over multiple projects for each week to see who will have capacity to take on new projects. In the past I've done it by hand to look like this and I know in my mind the demands of each phase for a given project. This is quickly becoming unsustainable as we grow. I have a task list for…
-
Help with Index Formula
Hello! I am creating one master sheet for a variety of portfolio metrics (we currently don't have control center - working on that!) and am having trouble figuring out the best formula to populate the data I need for this one item. I want to calculate how many strategic projects vs. KTLO projects a team has for the…
-
Automate RYG Balls based on Status and then date
Does anyone have a formula that looks at a line status (Not Started, In Progress, Complete) and then determines whether it is after the due date (red), <7 days (yellow) , or >7 days (green)? Complete would need to turn green regardless of the date while not started and in progress would look at the date parameters. Thanks…
-
Formula to generate a weighted average score
Hello! I'm trying to create a formula that will generate a weighted sum total across a couple of criteria columns after each column has been assigned a score. Each of the columns will have a drop down where we can select a score (from 1 - 10). Each column will have a different weight: Enterprise Priority: 35%; HR Priority…
