-
last, first to firstname.lastname@mycompany.com
Is there a way to take a column: Last, First and build Firstname.lastname@mycompany.com Scenario: 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 control over the original spreadsheet, (so cannot have the sender manipulate the data in…
-
Creating an Issue in JIRA from Smartsheet
Hi, 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 can't figure out how to add the Parent Key? Any help will be greatly appreciated Cheers
-
Are there Smartsheet Developers for Contract? If so, where?
Hi, 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 with creating a project management system to handle the sudden influx of projects due to…
-
Send an automated response to the sheet owner email address the moment I receive an alert ....
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? The backstory is that my condo association posts available units and the owner that…
-
Conditional Logic in Smartforms (AKA Cascading Dropdowns)
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 Smartsheet) is the need for Conditional logic or Cascading Dropdowns when completing forms in…
-
Smartsheet Microsoft Teams Integration Error
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 computer. Now when I select the tab the message "Please log in to your Smartsheet…
-
Task list for a card view? (like trello?)
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 "work". It just gives us an overview - which is the intention. To manage the work, we have…
-
Automated Workflow from Sheet to Diagram (flowchart, mindmap, org chart)
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, or org chart). I hope to have these documents dynamically connected so that edits to…
-
Smartsheet Form Multi Entry
Hi All, 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 dropdown for the user to enter these consumables which in turn will enter the required…
-
Apostrophe added to formula that is pushed from Zapier
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. =COUNT(ANCESTORS()) I use the value for formatting and for accurate issue counts as I only want to count…
