-
Index Match on Headers as Match array?
Hey all In SS, am I able to do something similar as in excel where I can do an index match looking at header names? E.g. Sheet 1 ColHeaders: Country | Apples | Oranges | Pears RowValue1: UK | Yes-Some | No | Yes RowValue2: USA | No | Yes - Some | Yes In another metric sheet 2 I want to be able to show: Fruit | Countriesโฆ
-
I need help with a SUM(DISTINCT(COLLECT formula
I am trying to sum the amount of opening in the Openings column for distinct REQs if they have an approved date of January. I keep getting the #invalid operation formula error. Here is my formula =SUM(DISTINCT(COLLECT({Openings}, {REQ}, {Date Approved}, MONTH(@cell) = 1))) Please help
-
Cross reference match formula
I am looking to cross reference Sheet A to pull in Time slots from Sheet B. Criteria I need to have matching from Sheet A to pull from Sheet B to determine the slot number or multiple numbers. Start Time End Time There could be multiple Slot Numbers so it would need to be a multi option that I could use later to separateโฆ
-
need to calculate NETWORKDAYS based on a checked checkbox in a different column "Days Away"
I have a Date column "Date" that lists all 365 days by month. The second column is a Checkbox type called "Days Away" where admin check which days they are away from the office. I need to calculate the total of the days away excluding weekends and holidays counting only the days that are checked in the second column.โฆ
-
Project Mgmt Changing Start Date
Hello, I am trying to create a project management sheet and have a question. I am new to project management as well. The sheet has a start date, end date, duration, and predecessors. If i go to change the start date to an earlier date, I get the following message: Manually changing "Start Date" will result in the removalโฆ
-
Trying to calculate the number of submissions
We just ran a survey in Smartsheet using forms, and its going through the next 2 weeks, i want to gather how many we have received from our survey document and display it on my metrics, to then display it on a dashboard. What formula would I use to do that? I was doing some research but i just keep getting #UNPARSEABLE
-
What formula do I use for my needs?
I have 2 sheets (see screenshots) and what I need is to have the Associate Name from the Associate List sheet copied to a column in the Permissions sheet but only if certain criteria is meet. If there is a date in the Yard Access AND GTDR Expiration columns, I need the Associate name listed in the GTDR Certified column onโฆ
-
Multiple nested IF(AND) paired with INDEX/MATCH ? or other way ?
Hello to everyone. Im starting to go deeper into advanced formulas and sheet reference, but have some issue... I have a "customer activity" sheet, where for each line, there is 2 sets of variables (5 in "activity", 3 in "types"...) and a "Duration" column. I would like to compute the "Final Price", by referencing a "priceโฆ
-
What am I doing wrong?
Trying to count how many of a certain type of ticket was opened in a specific month. I have this to count the specific ticket type (which does work): =COUNT([Reference #]:[Reference #]) I have this to count all ticket opened in January (also works): =COUNTIF([Date Opened]:[Date Opened], IFERROR(MONTH(@cell ), 0) = 1) Iโฆ
-
Formulas not working after adding year?
I'm getting one of our dashboards updated for the new year but the previous year didn't have the year part of the formula. I've gotten it added for most but I've run into a couple where when I add the year piece I can't seem to get it to work: =COUNTIFS({Relevant #}, 1, {Submission Date}, IFERROR(YEAR(@cell ) = 2025))โฆ