I'm wondering if anyone has created a managable way of tracking the status of employee policy attestations across 100+ employees and upwards of 20+ compliance documents. I've downloaded the Smartsheet…
I am trying to automate a monthly report that shows what staff member received work apparel. When someone received work apparel, they have to pay taxes on it. So I created a form for staff to fill out…
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would er…
So I think I've come close to this in the area of indexing, matching, etc., but I can't quite get the formula to work the correct way. I have a sheet setup to where it calculates the average number of…
Hello, I am setting up a staffing leave Smartsheet for my team and unfortunately I am getting the #INVALID DATA TYPE error message. There are 2 formulae set up within the sheet: Leave Remaining (the d…
I am trying to use the SUMIF Formula to reference a sheet to add hours based on the name of an employee. I have a Names Column with a list of names and an Hours Column. On a second sheet I am trying t…
I would like to send an attachment via Smartsheet/DocuSign API and set up already the template. But I can't figure out how to set up the mobile number in Smartsheet that the recipient can receive the …
I have a date column for noting when someone's contracted employment will end. I'd like to create a formula to reference that date, subtract 180 days from it if their appointment term is "Limited" els…
Hello! I am trying to use a function that will tell me whether a cell is vacant or full at today's date. We are trying to create a desk booking system for our office, so the end-goal would be to have …
Hi, I am fairly new to Smartsheet, and was able to create a sheet and a linked form to replace our old HR blast process. My question is this, I created a form, and we have a list of users who needs to…
