-
We're doing something that's never been done in F1. Help us power work that matters.
Community, as an official sponsor of McLaren F1, Smartsheet has been given a permanent spot for our logo on their cars. But during the upcoming Australian Grand Prix on April 10, it's not our logo that you'll see. We're giving our spot to DeadlyScience, an Australian nonprofit that provides STEM resources and learning…
-
Help with counting formulas and exclusions
Hi there, I'm trying to create a formula that would count all instances where a certain option is selected from a Multi-select drop-down and then it would subtract any instances if a certain category has been selected in another column. For example: This formula gives me 13 counts: =COUNTIFS([Curatorial…
-
editing across sheets for text consistency
Hi all, I'm not even sure what to ask for, other than help. I have three key sheets that contain many of the same fields. I've (finally) figured out the Index Match formula to pull matching field in from another sheet (there was much rejoicing!) but now am needing to be able to edit the info. Is there a way to do that…
-
Alert When Number of Rows with an "Open" Status Goes Above 300
Hi there! Has anyone tried this? We have one case for each row and they have basic open and closed statuses. Higher management wants to get involved in monitoring the list when the number of open cases goes above a count of 300. I added a hidden column with an if statement that will turn 1 when the number of open cases…
-
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…
