-
Broken Approval Workflow
Hi all! After a form is submitted, it needs 2 approvals. The first is approval is routed to the designated "Division Manager." During our test run, the Division Manager is able to receive and approval/ reject the submission. After the Division Manager approves, it is then supposed to route to the designated "Vice…
-
Trying to record time between changes in specific contact names
I am trying to record the response times of two individuals (A and B) when they receive notice of their name within a contact column (start time) and when they can remove their name from that column (end time). Note: there are dozens of other names in these sheets, but we are only focused on A and B. My thought is to…
-
Data Format for Contact List Column Type
We are using the Slack integration to add a row to a sheet through a Slack workflow. We are getting stuck with one column, it's failing when we try and populate a 'Contact List' column. Tried the following formats: FirstName LastName Email FirstName LastName <Email> FirstName LastName (Email) Is there a way to populate…
-
Lock filters in reports
Allow report to lock filters but still enable editing for those it is shared with
-
CountIFS with multiple criteria references
Hi, I have 3 columns referenced ("Available SYD","QoH SYD", and "Min SYD"). I'm trying to return counts where "Available SYD" is greater than or equal to 0, and "QoH SYD" is less than or equal to "Min SYD". If I change the last criteria to a fixed number e.g. <50, it works, but I want to use another reference "Min SYD". Is…
-
Data Shuttle - Track Changes Difference from Previous Upload
Hello, I am using data shuttle to upload data daily. I have track changes on to see the changes that were applied. However, how can I see what the difference was? Day 1: 100 Day 2: 102 The difference is 2...but how to see what the change is in a separate column?
-
Linked Smartsheet & Resource Management Assignments
Is it possible to drive work status, assignment name, etc from a smartsheet sheet linked to a resource management project? I can't figure out how to accomplish this. Everytime I do it it just changes the name of the assignment to the name of the project.
-
Unable to upload final proof from Smartsheet to Brandfolder in Report - missing custom fields
We have recently integrated Brandfolder and upload our final artwork to Brandfolder from Smartsheet, however I have found that you cannot add " custom fields" on the upload from a report, it says "no results found" when I got to add the custom fields. I'm hoping this is a future fix as we have multiple designers and using…
-
API sending data from DOMO to SmartSheet does not allow formulas to work
We are using the pre-built DOMO writeback connector to send data from DOMO into SmartSheet. The data is updated daily with the intent that rows in SmartSheet today will be cleared and replaced with refreshed data tomorrow. Consider this dataset 'A'. We have another dataset 'B' that is contained within SmartSheet and has a…
-
Multi-Level Blueprint/Navigation to Upper Level Blueprint
Hello I have a PMO system with three different blueprints. For simplicity we'll call them: Blueprint Level 1 (Top Level) = Client Blueprint 2 (Mid Level)= Program Blueprint 3 (Bottom Level)= Project When I provision a new project I need to be able to navigate upstream to Level 2/Program. Right now the process is to…