-
Creating daily work schedule for individual team members (from a master project grid).
Hello, I'm building a system in Smartsheet to manage work requests across all projects in my organization. The basic idea is for Project Managers to submit task orders to a common grid, which are then assigned to various team members. Ultimately, this new system will serve as the primary work scheduling tool. The system is…
-
Barcode Scanning
I want my supervisors to be able to open a form, scan a barcode and have the number associated with that bar code populate in a cell. Is this possible and if so how would one go about implementing that?
-
Subtraction formula with conditional IF statement from cells populated from index match
Hi everyone, I'm trying to create an inventory spreadsheet that auto calculates the QTY in the warehouse by subtracting the amount received from the amount signed out. These columns are populated via an index match formula cross referencing another sheet. I also need there to be the caveat that if nothing has been signed…
-
Python API SDK SSL: CERTIFICATE_VERIFY_FAILED Error
I am running into this error trying to connect smartsheet api via python sdk and getting this error on a mac book pro: smartsheet.exceptions.HttpError: (SSLError(MaxRetryError("HTTPSConnectionPool(host='api.smartsheet.com', port=443): Max retries exceeded with url: /2.0/sheets?pageSize=300&includeAll=False (Caused by…
-
Automation for creating a Template of new child rows when a Parent is copied from another sheet?
I'm working on creating some workflows that will copy information from a change order tracker sheet into a resource assignment tracker sheet. Ideally, I'ld like to grab key details from the change order tracker (number & name) over to a resource assignment tracker, then have additoinal rows added on the resource assignment…
-
Can you add additional data along with copying rows?
I'm attempting to connect some databases from different departments in a city-wide database, via form. Not all of their databases have a 'department' row, since it's not needed for them. Is there a way that, when the automation copies the row over to the city-wide datasheet, I can have an automation that auto populates the…
-
Sheet Title Formula?
Does anyone know if there's automation or a Formula where I can pull the Sheet Title into? For example, I want to create a "Project Name" column in a template that will bring the Sheet Title down to the row level. The use case is to then have a dashboard/report that will combine all my project sheet tasks into one. I know…
-
how to get automated workflow to trigger when a new row is added from a form?
I've created the automation below and would like it to run whenever a new row is added from a form. I've tested it out and when i create a new row the automation doesn't trigger- where am I going wrong?
-
Smartsheet + Google slides
I wanted to see if it would be at all possible to link a dashboard inside Google Slides where it displays on the slide, but is continuously updated? Thank you!
-
Room Reservation System using Dashboard- Calendar, Dynamic View, Form, Report
Hello all, I have seen a number of posts on this subject but none with the most recent updates in Smartsheet. I want to create a booking system that has a root back end grid in which each desk space (70ish distinguised by Room Number and with an added filter of Floor and Direction [2nd floor, 3rd floor West, 3rd floor…
