-
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…
-
Is there a way to log the email of a person submitting a form without requiring them to Login?
I have a Risk & Issues tracker on a Smartsheet grid; For people to submit a new Item we have them submit a form, but some folk with edit access are able to bypass the form (And it's required fields) by manually adding new cells to the sheet. We were able to track these using the Created By column, if the email was…
-
Current User Dashboard Help
Hello there! I am trying to build an employee portal where one of our staff can see a dashboard that contains just their information. I have two sheets, one that tracks TO DO's and one that tracks GOALS. I would like them to see only their assigned tasks. I know there is some way to set this up so the dashboard shows only…
-
Help For Colorblind Folks
Good morning! I struggle with trying to pick the appropriate colors from the fill and text palettes due to red-green color blindness. Would it be possible to have a text bubble with the name of the color pop up when you mouse over each color in a palette in any area of the application? It would be a huge help when…
-
Form that can perform math
Hello - I would like to use Smartsheet to collect resourcing information. Specifically, I would like to send a form once a month to each employee, and ask them to specify the percentage of time spent on each project they work on. For example employee 1 would enter Project 1 0.5, Project 2, 0.3 Project 3 0.2. The…
-
Multi- Row Solution
I am trying to create a workflow for an expense report that allows me to turn it into a PDF. Is there a way to utilize the generation of multi-row so I do not have to create columns for each individual expense?
-
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.…