-
How to pull a number from previous row into secondary column matching using a row identifier (name)
Above is the sheet I am working with. I am keeping track of a weekly score for each student and want to try and pull previous weeks scores into the current week row so I can track scores over the past month for a specific student. Currently the formula I am using to pull the previous week score into the column 'LastWk' is…
-
Deleting a user and automation
When I delete a person from the system (end of contract), is the person that also deleted from all the automation rules? - I get a large number of messages that a "workflow has become invalid". Thanks for any advice.
-
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
I was wondering if this 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…