-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
-
Organizational Charts
Has anyone made an org chart in Smartsheets?
-
Linking Sheets - Master sheet with multiple related sheets
Hi! I am looking to create a master sheet that contains personnel data elements used by multiple teams with different needs. The master sheet should allow data entry of new attendees while also pulling new entries from a related travel sheet. Example: Master Sheet Admin is aware of a new registrant and manually adds to the…
-
Can multiple users use the same sheet without causing changes for other users?
Sorry if my question is unclear. Here's what I'm getting at: I have an onboarding training checklist I made for all new hires. Each new hire has their own individual dashboard. Basically, I want to add the general onboarding checklist (which is a sheet) to each employee's dashboard. However, I want to know if there is a…
-
Help stacking COUNTIFS?
I have two fully operational COUNTIFS functions that calculate independently without issue. One counts how many absences occurred in a specific time range by referencing a date column on an attendance tracking sheet. The other counts how many absences occurred in a specific location by referencing a location column on the…
-
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…