-
COUNTIFS and NOT Formula Creation
Hello, I have a table of data that looks like this: I am needing to create a formula that will count all of the "1" in each column, that do not contain "OPEN" in the name field. So far I have created this formula: =COUNTIFS(Sun3:Sun27, 1, Employees3:Employees27, NOT("OPEN")) Does anyone have an idea for a formula that will…
-
Updating references on a template and deploying changes via SCC
Hi all, I am trying to update an existing metadata sheet in our solution build via SCC. I was able to make the changes on the sheet itself and have applied it at the template and test with an existing team dashboard. I realized after I will need to use SCC to actually make the change and then to all the retroactive sheets…
-
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…
-
Automation Issues
Good Morning Everyone, Happy Friday, I am relatively new to smart sheets and had a question in regards to the automation feature. So I have this sheet specific to techs out in the field and once they fill out what they are suppose to, they are able to check off a box for completed work. That will automatically trigger the…
-
Removing Shared Users
One thing that frustrates me the most is not being able to remove shared users easily. I know in the User Management section I can type in a e-mail address and have that person removed from all shares. However, I have 100+ shares. Why isn't there a list that shows me every person that is allowed to share on each sheet.…
-
How do I get a sum for each location (Room 600-605) excluding expired materials?
In this first image the "Complete Count QTY" column sums the materials excluding expired materials. This works perfectly. In this image you can see my attempt at getting a sum for Room 605 in the "Location Specific QTY" column excluding expired materials. This is where I have a problem. Ideally this would read 4 in the…
-
Is there a way to create multiple rows in a sheet based on a numerical answer on a form submission?
I'm trying to track new hires via work orders. I'm wondering if there is a way to create the number of rows indicated in a form submission on my tracking sheet? For example, should I indicate that I am trying to hire 8 individuals for a certain role, is there a way to automatically add 8 rows to my sheet that copy all the…
-
CountIf and Multi Select columns
I am trying to count the number of instances a value appears in a multi select drop down column, but I keep getting an unparseable error. After searching the existing help forum I have tried both the CONTAINS and the HAS functions as follows, but receive this error for both of them. The formula's I have tried are:…
-
Vlookup first non-blank match
Hi all, I've spent a few hours trying to find the solution and am about to give up. I've seen similar questions but the question/answers don't make sense for my brain today. I have 2 sheets: 1- One Sheet with a list of contracts. Some people have more than one contract, with some services included on one contract and other…
