Hello All, I’m needing help with creating a formula that seems a bit complex to me. I think it’s really a two-part formula or more. My data will span across two different sheets. My first sheet (Accepted Job) will have data where team members have accepted a Job on a new shift. The important data from this sheet is area,…
Hello - I need to set up a sheet based on an employee roster that will be updated quarterly. I'd like to use a Data Shuttle upload workflow to attach the updated roster to the sheet and have it automatically remove termed employees and add new rows for those that are new hires, without deleting the existing rows in the…
Hey friends, Anyone hiring experienced Smartsheet user, if so let me know! 😁 I've been using Smartsheet for 6 years, it's so much a part of my daily work productivity and I'd like to seek out another opportunity where I could transition my skills and background in program management into. I've gain so much knowledge and…
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 currently have: A hire date column: Brand Hire Date Anniversary date column (for the current year): Anniversary Date And…
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 used the ODBC connector to create several reports and tableau dashboards. In Visio, you have the option to create an…
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've tried having a seperate sheet that has the job codes and then I'm trying to use the averageif formula. However I keep…
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 sheets one that gets raw data from a form filled out by multiple therapists for between 60-80 different students and another…
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 several results, two of them being Establish Success and Success. I need to know the number of projects that align with Establish…
I wanted to showcase the sticker I created for ENGAGE 2022!
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 report but the sub-tasks are still showing up in the report although they were not selected. Perhaps there is a workaround or…
