-
Merging several form questions into one column
Hi! I have created a form but am having some issues with how fields from the form are collected and reported to employees. The form is a sign-in for sessions. Attendees select their presenter from several lists (e.g. A - C, D - F). These presenter fields are set up as Contact Lists and linked to our users, and each form…
-
COUNTIFS function with multiple criteria
Hello! I've been having trouble with getting this formula correct. Here are the details. I want to count row A when "service expansion" is present only if row B has "qualifying" or "proposal" or "Negotiation" listed. I've tried several variations but can't seem to get this one!
-
Formula to list all projects that asked for additional funding and count number of times
All, I want to do the following, if it is possible, for metrics that I need to include on my Smartsheet dashboard. I have tried variations of =COUNT(DISTINCT(COLLECT without success. Here is what I want to do: In a metrics sheet, I want to go to my "2023 IAP Tracker ELT Approvals" sheet, then automatically list all of the…
-
Index/Match
Hi all, I have a form that collects data to a sheet. I am setting up a metric sheet to map out dashboard for control center. Here is the data collection sheet: Here is the metric sheet: it is returning no match in demo when there is 2%. the other formulas are pulling in data on the left with no error. I have checked if the…
-
Copying Parent Row into same sheet column of Child Row
Hi, Is there anyway that we can copy parent row into the child row and apply to the whole same column without changing the parent row information? For example: =Parent({Test]@row) works if I put into the child rows only, but when I convert to same column formula the information in the parent row disappears so the…
-
Sintaxis de la fórmula específica del idioma en Smartsheet
Buen día, Smartsheeters. Actualmente, Smartsheet admite varios idiomas como inglés, japonés, alemán, español, francés y otros. Cuando cambia la preferencia de idioma en la aplicación de Smartsheet, la sintaxis de la fórmula se adapta para que coincida con las normas de ese idioma. Una de las principales diferencias es el…
-
Help with a complex Mutli Select Drop down formula!
Hello! I have a sheet which is connected to a form where the user can enter what services will be required (as a multi select dropdown option). What I want to be able to do is reference another sheet that has a 'practice' (line of business) that the service is related to and return all those values inside a second drop…
-
Basic Formula
Two different equations are being used. Equation 1: =IFERROR((SUM([RN Section 1 Score]@row, [RN Section 2 Score]@row, [RN Section 3 Score]@row, [RN Section 4 Score]@row)) / SUM(IF([RN Section 1 Score]@row = "-", 0, 0.3), IF([RN Section 2 Score]@row = "-", 0, 0.3), IF([RN Section 3 Score]@row = "-", 0, 0.2), IF([RN Section…
-
CountIF for a multi-select drop-down
Hello, I'm using a column to track what each row requires as a next step in the project. In some cases a row will need both say "requirement A" and "requirement B", therefore I'm using a multi-select dropdown because it makes the most sense for me. In the sheet summary tab, I want to be able to count how many rows need…
-
How to filter and average numbers by leader
Hello, I have been trying to write a formula to pull the averages of numbers in each column by Leader into a separate sheet but the only formula I could find that can calculate this is working, but pulling the data as zero. Is the issue because this is data generated from a form? The equation I am using is…
