-
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
-
Add a row to a sheet via Global Update
I have a sheet in each project created via blueprint and I need to be able to add a row to it. I'm looking for advice on how best to do this. For context, it's a sheet with a contact and an assignment for each contact. It can't be a single master sheet because the assignment can be different between projects. For example,…
-
Send QR Code in an Automation
Hello! I have a user that manages events. When an event is completed, she would like to automatically send an email with a QR code that will take the recipient to Cvent to complete a survey. My thought was to keep the QR code image in a Sheet Summary field and then link to it in the sheet via a column formula, then create…
-
Data Shuttle Offload - Distributed Flag?
Is there a way with Data Shuttle Offload to mark which rows have already been offloaded so they are not sent again? Like a distributed flag? This is for a conference attendee check in. The data shuttle offload would probably run every 2 minutes during the check-in window and I don't want to resend a row. Thank you!
-
Pulling Original Due Dates from updated Due Dates Cell
I am wanting to track, months into a project, where I originally had set the Due Dates. I have 300+ line items and I would prefer not to go in manually to update a new column with "Original Due Date". Is there a formula to pull that information from cell history so I don't have to manually do this? I sincerely appreciate…
-
Using Automations for Filtering a Daily Refreshed Sheet from External Doc
I am trying to filter a large sheet that will need to be updated Daily or Weekly from a company-wide Excel Sheet. I have already uploaded a copy on a regular basis that changes when rows are added but need Smartsheet to filter the data using several criteria from different columns so that I don't need to do it manually…
-
Unable to connect to Smart sheet API using the Python sdk
raise HttpError(rex, "SSL handshake error, old CA bundle or old OpenSSL?") from rex smartsheet.exceptions.HttpError: (SSLError(MaxRetryError("HTTPSConnectionPool(host='api.smartsheet.com', port=443): Max retries exceeded with url: /2.0/sheets (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED]…
-
Visual layout of Automation builder screen
I'm a visual person and I frequently find myself taking pause while trying to add on to automations that have multiple decision points due to the way the builder lays out the decision points. It slows me down and makes me second guess if I have placed the decision point in the correct location. The decision point is…
-
Does anyone use a Change Management Form in project work and have a dashboard?
Hello. Our PMO is beginning to use smartsheet as our primary tool. We're starting with basics and have created a project plan template that also rolls up into a dashboard. We would also like to track change requests and have an overview for reasons, # of requests, # of date changes made due to requests, etc. Do any of you…
-
Formula Help
I would like a formula that counts the # of entries that are marked for the event "Non-Public Schools Leadership Conference" that contain an admission item marked "Exhibitor" whose payment method is not marked "Free". What am I doing wrong in the formula below? =COUNTIFS([Event Title]:[Event Title], "Non-Public Schools…