I have a Smartsheet tracking our team member work anniversary dates so that supervisors get alerted prior to a work anniversary occurring and then can congratulate that team member on the day of. I cu…
Hi All, I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have u…
I'm sure this is user error but I'm trying to average out compensation based on the job code then I'd like to create either a data mesh or vlookup to fill in the blank compensation with these averages…
I'm pretty new to Smartsheet and I have a pretty big set of data for each one of my 60-80 students I am trying to use it to track. I manage a therapy department at a special ed school. I have two shee…
Hello everybody! I need help with a formula that I am not sure how to enter for what I am looking for. I am building a dashboard on certain metrics that align with a key result. For this we have sever…
Is there a way to build a report consisting of only parent row information? I am trying to show overarching HR Processes in my sheet (parent row) without pulling in the sub-tasks. I tried a checkbox r…
I am looking for a template that allows employees in training and conducting training to report their progress, a notification system that alerts me to concerns raised, and an end dashboard I can use …
Hello, How do I create a form that will allow a user to reserve a desk for a particular day and remove that desk from a list of available desks? Within the same form, I will also need to allow for rec…
I need for updates to Profile sheet to pull data from Exception sheet only when the date is reached based on the employee #. Scenario: An employee wants to increase their 401K contribution by $100 eve…
