-
Employee Verification/Consent/Sign Off
Hello: I am looking for a streamlined solution that will allow us to obtain employee verification/sign-off acknowleding they've reviewed a document. Does SmartSheets have a template that will allow you to import your employee listing to allow them to sign-off and monitor responses? Would be great if reminders could be sent…
-
Decline License Requests
Hello Everyone, It looks like Admins now have the ability to decline a license request instead of getting reminders and having the request stay open in Account Admin indefinitely. That's a great enhancement. Does anyone know whether the requester gets notification that they've been declined? I'm looking to clean up some…
-
Formatting Cells with Color
Hey All, Question for ya! Hoping someone can solve this for me. I have created conditional formatting to turn a cell GREEN if a date in a cell falls ahead of a projected date, RED if a date in a cell falls after a projected date, and BLUE if a date lands exactly the same date as the projected date. Here is the formula i…
-
create workflow for "task due in 3 days"
Hi all, I would like to create a workflow to send out reminders to assigned persons of tasks (cards) 3 days before the task is due. I set-up the attached workflow but at the moment it's sending reminders on the exact due date and not 3 days before. Would be happy to get your advise. Thanks so much! I'm using smart sheet…
-
Workflow notifications
I have created 2 workflows as pictured below. The first workflow is for "is not one of" and the second workflow is for "is one of." Based on the parameters, the "is not one of" workflow should not have gone off today and the "is one of" should have, but instead "is one of" did not work and "is not one off" sent the…
-
Calculating Sum of Hours from Child Rows
I am trying to sum up the "Total Hours Used" from Child rows (white highlighted) into the "Total Hours Used" parent row (black highlighted). I cannot use StartTime and EndTime here, because the time slots are not necessarily continuous. Appreciate any inputs on this. Child Rows - "Total Hours Used" Calculated as 2 hours, 4…
-
Search Bar Question
Is there a way to add a Smartsheet search bar to a web site, linked to my smartsheet?
-
Need a Work Around Please
I have an Admin who doesn't wish to share the sheet with me so I can add a column to covert the date in the date column to a Weekday, Is there a way to do this on a separate sheet? Our, Both the Admin and I, have superiors who want me to create a report showing the total orders scheduled by day of the week and then I have…
-
RYG Automation using IF/AND function
Hi, I am creating a project management sheet with RYG symbols to trcak our progress. I have a sheet with the projects, status and due dates. What I'm trying to achieve is for the RYG symbols to automate based on the status and deadlines. If status is either in progress or for review, and is 2 days before the due date,…
-
How to create report with rows instead of columns?
Why does Smartsheet only allow you to make a report with columns and not rows? I'm using my sheet to coordinate data for events. Each row has a specific event, each column has different details for the events (date, location, hotel, meals, etc) and I need to take information from only certain rows to create a report for…
