-
Using Smartsheet to create Time Off Request Calendar, Dynamic View, Form, Report, in Dashboard
Hi all, Through some trial and error I created a Time Off Request system for my team (80 people) I started with grid rows: Employee Email (text), Supervisor Email (text), Division (drop down), Time Type (drop down: Vacation/Personal/Admin/Comp OR Sick/Bereavment/Jury Duty), Start Date (date), End Date (date), Partial Day…
-
Employee Scheduling
Does anyone use Smartsheets for employee scheduling? I have about 25 people across four sites that I schedule. There are changes everyday. I also need to save a history of the schedules. I currently use excel and google docs. Thank you. Robert
-
Form Data Validation Against Dataset
The ability to control text form entry against a large dataset. For example, I have a form that went out to 1,500 employees. The primary column is their name. Now when I want to check who has vs. has not completed the form, I have to manually check for false negatives due to slight differences in how they typed their name…
-
formula for 30 days then the 1st of the month following
I am wanting a formula for new hires to be based off their hire date and to generate a date that would be 30 days after they are hired following on the 1st of the month.
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
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…
