-
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…
-
Merged: Define A Column as either a String or a Number
This discussion has been merged.
-
Getting a specific date of the month to show in a date field.
A quick background of the build. I am building a sheet that show an "Activity" and its "Date to be Completed by", along with other columns but for this question they don't affect anything. I have a bunch of formulas to get specifics days of the week or to have a task reset its date to the next day and so on. Currently I am…
-
Unsure where WORKDAY fits in with a VLOOOKUP to another sheet
A sheet has task start and end dates for various product tasks. The products and tasks are listed in a separate project task lookup sheet. The Task End Date is calculated as x days from the Task Start Date, depending on what the task and product is. Both columns are Date columns. This formula works, but it doesn't exclude…
