-
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…
-
Card View - Lanes by Parent Task?
My sheet is setup with the following levels with how tasks are nested - see screenshot. In the card view, I want the lanes to be the Project Setup level tasks. I have a column formula where I am extracting the parent name and then viewing the lanes with that, but that is pulling everything at the Task 3 level too. How can…
-
How to Nest IF statements in the correct order
I am tasked with collecting labor rates per employee, but the labor rates change based on the dates posted. For instance, I have old labor rates applied to dates older than December 1st 2023. We recently had some promotions and now I also have to pull labor rates after March 28th 2024. The labor rates after March 28th are…