-
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…
-
DataMesh - Updating ONLY new lines
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 updating that row anyway - is there any way to ignore "old" or existing requests?
-
Multiple forms with unique dropdowns
Hello, 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-downs for every form. Would this be possible? When I plug in the values for the…
-
Capture metric each day and add to new row
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 good solution for it? Example of metrics I'm collecting on-the-fly from Control…
