-
#INVALID DATA TYPE on an IF( function
I have a formula that I'm trying to get to solve the following situation: If someone has worked for less than 2 years (<730 days), the "destroy on" date should be their hire date plus 3 years (ex. hired on 1/13/2021, destroy on 1/13/2024). If someone has worked for 2 or more years (730+ days), the "destroy on" date should…
-
Solution Spotlight (HLS)- Dynamic View for Insurance Verification & Accreditation Processes
Hello all! On Tuesday, 1/7/25 at 11:30am PST/2:30 EST the Healthcare & Life Science (HLS) Solution Engineers are putting on a Solution Spotlight Demonstration of two unique solutions utilizing Dynamic View to securely control data. The registration dashboard is here (no account required, and even if you can't attend we…
-
Merged: Request for Country-Specific Holidays and Multi-Currency Support in Resource Management
This discussion has been merged.
-
Cyclical or Yearly Events
Every year, employees need to update their benefits, complete their performance reviews, etc. How do I add a cyclical event to a project plan? Visuals are greatly appreciated! Thanks! Millie
-
How can I use Smartsheet for Resource Management from scratch?
Hi Everyone, I recently came across a YouTube video mentioning that Smartsheet can be used for Resource Management. I'm interested in exploring this feature, but I'm not quite sure how to get started. Could anyone from this community guide me on how to effectively use Smartsheet for resource management from scratch? Any…
-
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…