I've been working on connecting Teamwork Projects( A project management software) to smartsheets via the API using zapier. I'm curious if someone has found a way to add new tasks in smartsheet under parent tasks as subtasks?
API & Developers7Thomas Gunn
I am trying to automate a workflow with Smartsheet. It starts with a large survey (external to Smartsheet--Forms can't handle the requirements), whose results are inserted into a Sheet.
Whenever a new row (survey result) is added to that …
Using Smartsheet72Mike Mitchell
Is there a way to take a column:
I have data that is emailed to me as a cut and paste of part of a table. I send an email using the names included in this data. I have no co…
Formulas and Functions11Jennifer Seymour
I'm using the JIRA connector and I'm getting an error -
"Invalid response from JIRA. statusCode: 400, reasonPhrase: Bad Request Issue type is a sub-task but parent issue key or id not specified."
When I edit the workflow I…
API & Developers100@RunningBeare
I hope you're well and safe!
I've developed a solution that lets you store the date or value.
You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work.
We'd trigger the copy-row to another sh…
Formulas and Functions133Andrée Starå
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.
I would like to have a form where someone selects one op…
Formulas and Functions2379Dajah
My company has been using Smartsheet for the better part of 3 years now. Some staffers have had training but nothing too extensive. My company recently merged both the Communications and Marketing departments and I have been tasked wi…
API & Developers19Travis Pryor
I share as a viewer for a smartsheet model for which I receive alerts when the model changes. Is it possible to send an automated response to the sheet owner email address the moment I receive an alert that has certain characteristics?
Using Smartsheet14Fred Givhan
I have quite a number of columns and I don't want all of them displayed in the panel until a trigger is reached for a grouping of each section. For example, until a recommendation is approved, I am hiding about 20 columns. Once approved,…
Premium Apps and Integrations34jmtrix
We all love a Freebie?
OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsh…
API & Developers1262Richard Rymill SBP
I am currently experiencing an issue with the Smartsheet application within Microsoft Teams.
When I first added a Smartsheet Reports as a tab in Teams, I logged into Smartsheet via Teams and the reports functioned fine until I restarted my…
Premium Apps and Integrations29Lindsay Gehrls
We currently use a portfolio sheet that tracks our pipeline of clients and organizes them by stages. We love this sheet as it provides us with very useful management level information. However, it does not allows us to manage the "wo…
Premium Apps and Integrations138Jef Forward
I am looking to utilize Smartsheet for hosting a document. I am looking to map some of the data in this document to a second sheet/document that is a diagram/visualization with boxes, arrows, and labels (similar to a flow chart, mind map, …
Using Smartsheet23Matthew Moliassa
Just have a query regarding Smartsheet forms. I am currently setting up a form to track consumables for a project. The project may have up to 20/ 30 different consumables associated with it.
Is it possible to use a multi-select d…
We’re using a sheet for ticket tracking. Issues come in via a form, manual entry, or the Gmail Add-on. We’re using hierarchies to track To Dos as tasks. I use a simple formula to tell me if a row is a task or a parent.
Formulas and Functions22Cheryl Lock
I know that the smartsheet charts app is still in production, but is it possible to have sheet containing North American states and hyperlinks, then using the 'map' chart, click on a particular state and then it will take you to that hype…
API & Developers286dwayne.waterman21236
Using a Dashboard to run our weekly meetings and had an idea to add in a timer inside the dashboard to stay aware of how much time we have left to discuss each topic.
Smartsheet doesn't allow any domain that I know of that can allow…
I have a DataMesh sequence that I run that where the source sheet can have 1 to N number of entries, and it's valid. As I understand it, DataMesh only allows me to select two options - Pick First Match and Ignore Entries. In either of thos…
Premium Apps and Integrations19Mike Rini
I'm having trouble embedding a powerpoint file in my Dashboard. Whenever I add the link, I get an error message (photo attached).
(Image) Currently, I go into my powerpoint file, click File, and then Share -> Embed and copy/pa…
Using Smartsheet31Jean Ye
Is there any way to automate merging all of the attachments of a sheet into one PDF? I was thinking of using zapier or Microsoft Flow but I haven't been able to figure out a good and simple way to. Ultimately I want the end users to be abl…
Premium Apps and Integrations21Julia Peterson
We setup a Smartsheet Admin account so that there is no one person owning the Data Uploader scripts, but rather this shared account. This works well. In addition, we have a different OneDrive sign in that we need to use to pull the file(s)…
Premium Apps and Integrations34[email protected]
I am using MS Forms to collect information and using an integration through Flow to insert responses into Smartsheet. Answers that require a # (I.E. salary or years experience) are being inserted into Smartsheet with an ' before the number…
Premium Apps and Integrations298Lindsay AR
I'm using Pivot App to summarize the number of records from a variety of reports. It works great, but if there are no records in a report, the pivot table will report blank. I was hoping for a "0" value, as I'm pushin…
Premium Apps and Integrations98cmondo
hi! I am trying to build a means to automatically forecast vendor costs, based on a count.
I have a large sheet that contains an intersection of many Locations and the Scopes that will be applied to each location. I have different vendo…
Premium Apps and Integrations51Jennifer.Stangret
I searched and I didn't find anything for this so I am hoping I did not just miss this.
We are trying to tie our data into Microstrategy for more visualization options. We are using the Live Data Connector. Has anyone been able to …
Premium Apps and Integrations34Liz Beall
Hi - we get two-halves of requests from separate parties, and I'm using DataMesh to link to things based on a Unique ID. Once the second half of the request is in the sheet, I don't need to update it again. Right now, my DataMesh setup is …
Premium Apps and Integrations8Mike Rini
I currently have a smart-sheet that gathers data from multiple vendors (each vendor has a form). One of the columns is an ID which would be entered through a drop-down. The functionality we are looking for is to have unique drop-dow…
Premium Apps and Integrations50Koushik Ganesh
I have a number of Harvey ball metrics (count of red, yellow, green tasks) and things that change every day. I haven't really seen any way to capture and store these each day at a particular time (or hourly, weekly, monthly). Anyone have a…
Formulas and Functions17Ezra
I have a user added as an Admin to both the Workspace and the Dynamic Views and still unable to access the Dynamic Views, they won't even show as available in the Views menu. The shared users can access said DV's. Any ideas why the…
Premium Apps and Integrations19Silvia Rangel
I am trying to send alerts from Smartsheet to Slack but it is only displaying the primary column and the column that changed. On this page https://help.smartsheet.com/articles/2476711-smartsheet-slack-notification it says that you can disp…
Premium Apps and Integrations128NickF