- trying to compile "other" comments from a survey
Hi! I am trying to compile survey data into a single page. The same survey will be used over and over and the data will keep adding to the data sheet. I have a few multi-select dropdown columns, which each have an "other" category that then opens up the "other" field in the survey if selected. Often, this is not used. I am…
- How to I "not format" a number in a form?
One of the questions on my form is what year(s) someone attended our annual meeting. The format is text/number. if someone attended in 2016, 2017, and 2018, the answer is being formatting with commas and displays as 201,620,172,018 even though I typed it as 2016, 2017, 2018. The only way around it is to direct people to…
- Removing Rows at Bottom of Sheet - Affecting Formulas on Dashboard
There are about 10 blank rows at the bottom of my sheet that keep coming back, even after I delete them. I either need to know how to permanently delete them or how to adjust my formulas to not include them because they are affecting our dashboard results. Any help or advice anyone has is welcome. Thank you!
- Maximum Downloads
Has anyone ever encountered this issue? We sent out a single line from SmartSheet that held four attachments to approximately 180 individuals to download. For most it worked wonderfully. Now, we're getting this message: "Unable to download file. The download URL has exceeded the maximum number of uses." Of course, I now…
- How Special Olympics grows their global community
Hello Smartsheet Community! Just in time for the holiday season, we are shining a light on one of our amazing partners, Special Olympics International (SOI). You may know their vision of providing skills and opportunities to children and adults with intellectual disabilities through sports, but did you know they also…
- How to enable Work Insights or when does it launch?
I was watching this video https://www.youtube.com/watch?v=K4tuWf3__Cw&t=506s&ab_channel=Smartsheet but I don't see the feature on my Smartsheet account yet. Is WorkInsights an additional cost or is it not launched yet? Thanks
- Import Outlook Calendar into Smartsheet
我想知道is is possible yet, or if there have been any updates? https://community.smartsheet.com/discussion/how-import-outlook-calendar-smartsheet Importing from Smartsheet into Outlook is nice, but I would love to have a 2-way possibility. I have a lot of projects going on all at once, trying to keep up with…
- Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
- How do I create a report that sums totals from my sheet?
Hi, I need to create a report that sums up the totals of each quarter on a report. How do I do this? I would normally use a pivot table in Excel for this, but I'm not sure how to recreate that same functionality in Smartsheet.
- Nonprofit looking for assistance expanding template set
Hello All, I'm in Operations at a nonprofit. I am hoping for assistance in building out the Template Set for Objective and Key Results (OKR) Tracker. The template set is built for 5 objective. I need it built out for 12 and I am running into difficulty connecting cells/sheets and formatting. I have a blank copy. If someone…
