-
IF formula to pull biweekly updates
I'm trying to create a form that I send out to partners on a biweekly basis. I'm working with partners from 5 different countries, and I want their updates to be pulled using the sheet summary into a dashboard. Is there a way to do an IF formula with an INDEX formula to get the following results: IF [Country] is listed as…
-
Weekly requests Received & Sent
Hello! I am trying trying to come up with a formula for a Sheet Summary field that can output the number of received requests and number of sent requests over the course of the current week for each member of my team. I have a [Received Date] Column and a [Date Sent] Column where the dates are inputted but I just need the…
-
Sheet Summary Formula
Asking for help again with a formula. I need to create a formula in Sheet Summary that rolls up how many participants from each of the 10 columns above attended which "Program Type." Program Type is a dropdown. For context: How many Blue Ridge participants attended "PSUDS ECHO." Wondering if the structure of the sheet is…
-
Sheet Summary field suddenly started to append date with time of day
A Sheet Summary field that concatenates the next scheduled task name and due date suddenly began this week to append the date (MM/DD/YY) with the time of day (HH:MM). No changes were made to formula. Example: Formula: =IFERROR(INDEX(COLLECT([Task Name]:[Task Name], Actual:Actual, ISBLANK(@cell), Status:Status, "In…
-
How to Identify Skipped Number
I have a column containing document numbers that looks somethin like this: s-001 s-002 s-004 Does anyone know of a formulas that I could put in the sheet summary to return the first skipped number (in this case, s-003)? I know how to do this with a "helper column", but I'd like to avoid that if possible.
-
Adding multiple columns if one column equals X
I have a multi column sheet. If column Alone= CN, I want to total four columns. =SUMIF([$ Regular]:[$ Regular], [$$ xyz 2021]:[$$ xyz 2021], [Per Item $ 2021]:[Per Item $ 2021], [null 2021]:[null 2021], [Revised $$]:[Revised $$ ], (Alone:Alone, CONTAINS("CN", @cell)) I've tried ever iteration and I cannot figure it out.…
-
Is there any way to filter a row report by a sheet summary field value?
As an example, I have hundreds of project sheets in a workspace. Each sheet has a sheet summary that defines the owner, type and status of the project, among other things. I need to get a row report of open tasks, but I only want to include sheets that have a sheet summary status of Follow Up. I don't want to have to…
-
Is there a way to COUNTIF checked boxes, but have the formula skip over boxes with an error?
I have successfully implemented a formula in a sheet summary that COUNTIFS checked boxes in a column but because of the nature in which this sheet is being used, some of the checkboxes that I am counting have temporary #NO MATCH errors due to information not yet being available from other sheets which is thus causing the…
-
Sheet summary - column formula
Hello, I am creating a smartsheet that aggregates the clubs that certain employees are in. That main component is done, and I am now using the sheet summary function now (mostly using COUNTIF) to link to a dashboard. However the number of entries on the sheet will change with new employees, which makes the sheet summary…
-
COUNTIFS Formula in Sheet Summary Returning "#NO MATCH"
Hi all, I had a formula in place yesterday that was working fine, but this morning is returning no match. In our sheet summary, I am trying to count the number of quarantined individuals in a specific market. Here is the formula I was using: =COUNTIFS(Market1:Market1832, ="NE/IA", Quarantined1:Quarantined1832, <>"") The…