-
Hi everyone, is there a way to create Dynamic view on a dashboard but with charts and metrics?
I am making a supplier-facing dashboard and I would like to make a dashboard that displays personalized data, similar to this video. Instead of a Month dropbox it would display supplier names and the data would ideally display specific or personalized info.
-
Why do I get #invalid value?
Hi everyone! I am using this formula in the Date column to pull a date if 2 criteria are met (name of the client and the specific module): =INDEX({Date}, MATCH([Column11]3, {Client}, 0), MATCH([Column4]@row, {Module}, 0)) It works in the "Module 1" row, but not below, any idea why? Thanks!
-
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…