-
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…
-
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…
-
Why are $ used in some formulas?
Can someone please explain the purpose of the "$" in this formula? =IFERROR(DATEONLY($[End Date]$198) + "", "") Is there a benefit to having those in there? I know the formula will run just fine without them, that's why I am asking. Thanks in advance!
-
Conditional formatting - when a date is older than....
Hi, I'm looking for a way to highlight lines on a Smartsheet where the start date is older than three months. Is there any way to do this through Conditional formatting? I can't seem to figure it out...
-
Report not updating formula unless the underlying sheet is opened and "refreshed"?
I have a report that brings in a bunch of sheets with one of those "this task was due 15 days ago" or "this task is due in two days" types of formulas. So this report has a due date and this text narrative. I run the report, and the text is wrong. Like Due Date will show a date in the past, and the narrative will say that…
-
Dollar Sign Not Showing in Metric Sheet
Hi Everyone! I'm not great with formulas, and I was hoping someone might be able to help me figure out what I'm missing. I have a column in a sheet that contains dollar amounts. I then have a separate metrics sheet where that column totals (to be pulled into a dashboard), however even though the source sheet contains…
-
Smartsheet and Genesys Cloud
Hello we are using Smartsheet and sending emails to Gensys Cloud for automated email routing. We are having an issue that when the agent replies to the email, the automatic process is to reply to the FROM email address, which happens to be the Smartsheet email. We need it to go back to the actual person who filled out the…