-
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…
-
Datamesh from a summary report
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 vendors servicing my various locations. I have created countifs formulas to count the number…
-
Apostrophe being inserted before number when importing from web form
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 which results in my formulas not working. I need to find a way to make this work…
-
Microstrategy
Hi all, 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 successfully integrate Smartsheet and Microstrategy? If so, I'd like to speak with…
