-
Approval Automation
Hi, What is the most efficient way to set up an approval automation for 30+ approvers? For example, I am building a Travel Request form, which requires approval from managers across numerous departments (over 30 departments, one manager for each department). Do I have to manually input each of these managers as an…
-
Bridge API Call Error
I'm trying to use Bridge to access the API and sort my sheet. When I run it in Postman, everything works as expected. However, when I run the command through Bridge, I get an error. Error 1004 "You are not authorized to perform this action." I am using the same token and have everything set up according to this tutorial: I…
-
Data Shuttle Offload keeps deleting other Excel tabs
New to Data Shuttle. I created the offload workflow successfully to an excel tab and it overwrites the entire file. My other tabs which will calculate the data on tab 1 after it's refreshed just disappear. What am I doing wrong, please?
-
Control Center & Multi-select dropdown
Hello. I'm looking for some feedback on a control center process we've built. We have an intake sheet with standard and optional department assets depending on intake data. To mark which assets we need to create, we have multiple columns with multi-select dropdowns for each asset by department name. What my goal was to…
-
Formula for totaling 2 selections from a drop down in sheet summary
Hello,I am trying to write a formula for my sheet summary. I would like a formula that gives me a total number when Instructional Design and Learning Solutions is selected. I have been successful with the countif formula when I want to count just one criteria but not two.
-
Copy Sheet w API doesn't copy over "Cope Rows" Automation action
I am using the Smartsheet SDK When I copy a sheet using the API (either by copying a template w/ client.Workspaces.create_sheet_in_workspace_from_template or client.Sheets.copy_sheet) I can use the "include" query parameter to capture conditional formatting, forms, and automations copy over, but a specific COPY ROWS action…
-
Blank rows added after a new entry is created through form, why?
Why is it that it keeps occurring to me that when I get a new row of information (populated by a form) about 10 additional BLANK rows get instantly added on my main sheet? I have to keep deleting this manually and it's just adding a ton of manual work. Any explanations, solutions to this?
-
#Invalid Ref using Marketing Campaign Management Template
I used the marketing campaign management template and created a new campaign, however under my campaign Info sheet I am getting a #invalid ref on all cells. I have verified the formula is correct and the range (using the sample campaign as a guide) and am at a loss. Because of this error the information on my campaign plan…
-
Remove GO to sheet option
There should be a way to remove the "Go to the Sheet" button / link at the bottom of an update request. Often users do not have access and then they keep requesting access by using this link.
-
"Edit" Option in Publish Reports
As a user i want to Publish a Report and have also the option "Edit" in the sharing properties , (not only "View " )this because i can embed it in a Dashboard and modify it from there