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 …
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 f…
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 case…
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…
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…
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…
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 …
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 includ…
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 ge…
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 providin…