-
Survey Score Formulas
Hi! We are launching a customer satisfaction survey this week. When completed, they will want a dashboard showing results. We have 5 departments with 2 questions each. The scoring is shown in screenshot below. I need to create a formula that will tally results and also give average score. My problem is that it's not just…
-
Should I use Join / collect or Multiple If in this situation?
Hello Experts, I need some help with this formula, I am trying to auto populate the Category Cell based on the check box value. Right now my formula only works on the first Sports checkbox value return. =IF(Sports@row = 1, "Sports", IF(Entertainment@row = 1, "Entertainment", IF(Community@row = 1, "Community"))) Should I…
-
Can a Sheet Summary field be included in a workflow automation?
In the SUBJECT LINE of a workflow automation UPDATE REQUEST email, I'd like to include a sheet summary field by using {{sheet summary field}}. Is this possible?
-
Formula
So, I'm tracking payments of invoices. I want to use the RGY balls but only the Green and Red balls to be designated in my Paid in Full? column. I am using the Invoice Amount and Payment columns to set up my formula. So far, the first part of my formula works. Whenever the invoice amount equals the payment, the Paid in…
-
Formula Question
Hi, I’d like to know if it’s possible to add information from one cell to another using a formula, meaning, I have Column A, and Column B, I’d like that when I enter 1234 in Column A Cell 1, it should also Display 1234 in Column B Cell 1. But without entering any formula in Column B. Is that possible? This way, I can have…
-
I need to set a count.
This count needs to count data in the last 7 days and only count data once and not count duplicate data. my goal is to get a count of the names of the people that have completed the form this week at least once, but do not want a total count of all the forms this week. this way i can say that 30/42 people filled out forms…
-
Populating a dropdown list (Single select)
Is there a way to populate a dropdown list from a selected option of another dropdown in the same sheet? I have a columns named: Tech, Team and Supervisor. If I select Team 1 in the Team column I need it to populate a dropdown for the Tech column with only the techs assigned to Team 1. I have another sheet called Employee…
-
Saving a file set (with vlookups across files ) as a template Set
I would appreciate your help ! I have created a template set ... 3 files in the set File1 - Scoreboard File2 - Upload Sheet File3- Upload Sheet 2 Master data across the files is the same, File 1 has a vlookup to file 2 & File 3 to upload actual results. File 1 has calculated scores based on File 2/ 3 results. I have set…
-
NETDAYS with Contains...or maybe IF....
I have a multi-select column and a created date column(System). Im trying to get the netdays since at least one selection in the multi select was chosen and a row was created for it. I know Im missing a CONTAINS in here...I think...help is appreciated. =IF(Pri/Sec/Base/Water/Sand @row = "Primary", TODAY() - [Created] @row,…
-
COUNTIF formula for a date range
Hi, I am brand new to SmartSheets and trying to pull some high level metrics from a sheet into the Summary section. I have never used complex formulas before in Excel or SmartSheets and am trying to find the most basic answer around how to build a COUNTIF formula to show how monthly numbers for my team. My sheet has 3…