-
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…
-
Using Dashboard to run meeting - Ideas to add in a timer?
Hello! 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 me to embed a timer... So I tried a workaround. Embeded a Google Data Studio Report,…
-
DataMesh - Duplicates In Source Sheet
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 those scenarios, I'm not going to get all of my entries. Is there another way around this…
-
Can I use a different OneDrive account than my Smartsheet Admin account?
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) we are uploading. This seemed to work one time when the script was built, but it…
-
Can't embed powerpoint into Smartsheets dashboard
Hi all, I'm having trouble embedding a powerpoint file in my Dashboard. Whenever I add the link, I get an error message (photo attached). Currently, I go into my powerpoint file, click File, and then Share -> Embed and copy/paste the iframes code. I have also tried Share with People and copy/pasting that link into the URL…
