-
How to prevent IF function from removing cell data when false
My team is currently tracking customer services and monthly rate before and after talking with an agent, using a form that I created. I am trying to set up a formula that if we select that there are no changes made to the account it will copy over the data from the incoming fields to the outcoming. I am using this IF…
-
What Formula to use to Count the number of Unique Dropdown Phrase Utilized
I'm new to Smartsheets and I've been tasked with going over the SWOT data. They are asking me to go over each category of SWOT with the unique data point they captured and tallying how many times that data point is utilized. The Data Point Column is a dropdown list. For example, I am having a hard time counting how many…
-
Counting items within a cell
Hi team, I am wanting to keep track of why people are exiting the company on a monthly basis. I have the following formula which works perfectly if the exiting employee only selects ONE reason why they are leaving - =COUNTIFS({HR-559 Exit Interview Range 1}, OR(@cell = "Better job"), {HR-559 Exit Interview Range 2},…
-
#Invalid Ref
I'm trying to reference another sheet and get a count of items that meet multiple criteria. My formula syntax is =COUNTIFS({173000 High School UUU Model Review Items Range 1}, "3-Critical", {Phase}, "CD") Do I need the function HAS? When I've tried inserting HAS, I get UNPARSEABLE. With the syntax I have now, I get…
-
COUNTIFS Formula to calculate the number of values in a column with multiple values and parent rows
Hello, I'm trying to help a colleague set up a metrics sheet that can help them report on the number of skills they have within their department. There's a sheet of all the people in the department, which has a record of the person, their skills and what they are booked to work on. • Each of the people records are assigned…
-
Check box formula help!
I am wanting to set up a formula and/or conditional formatting so that when you check one box, it automatically un-checks another. example: two columns side by side. one titled "job started" the other titled "job done." I want it so as soon as you check the box for job done, it removes the check from job started. This…
-
Name different weeks by IF(AND Formula and WEEKNUMBER.
Hello! I need some help to make my simple formula more efective! What I want is according to my [Start Date] know the week number, and depending on that number have another column saying if it's the current week, past 1 week, past 2 weeks, and past 3 weeks. So my formula is this one =IF([Week Number]@row =…
-
Flag duplicate titles but not if the title is blank
Hiya, I am trying to write a formula that flags entries if the content of the title column is repeated, but I need it to ignore entries that have a blank title. My current one is: =IF(COUNTIFS([Conference Title]:[Conference Title], [Conference Title]@row > 1, [Conference Title]:[Conference Title], [Conference Title]@row) =…
-
Sum Values in the Range of the Cells
Dear Colleagues, I have a list of products and their quantity. Several lines can belong to the same order. My task is to sum up all the values in the "Quantity" column if the value of the "Order Number" is the same. Which formula would you recommend I use? Order | Product | Quantity | Sum of Quantity O1 | ABC | 10 | 11 O1…
-
How best to automate moving data from one sheet to another based on certain criteria?
I am trying to reference a list of people in Smartsheet A and pull associated data based on that list into another Smartsheet B. I have people listed this way: Column1: Last name, Column2: First name, Column3: email address. Also in Smartsheet A (Column6) there is an alpha numeric designation associated with each person…
