-
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…
-
Sheet Summary equation
I am trying to create an equation in a Sheet Summary field that counts all items that have not passed approval. This would involve counting all items in the Status field that are Not Started, In Progress, Failed, or On Hold. I have tried multiple variations of the CountIf and CountIfs statements, but everything is…
-
Sheet Summary for Dashboard
So i have multiple sheets (15) which are all using the same template of marketing events. i created a dashboard which shows upcoming events in the next few days based off a report (pulling from the 15 sheets). I would like to add a metric on the dashboard which show (for example) how many webinars we have going across the…
-
Can a sheet summary always reference the same cell when form entries are added?
I am trying to create a sheet summary that pull information from a form entry. The form entries will always appear in the first row. However, even when referencing the absolute cell, when a new form entry is populated, the sheet summary field displays the previous row (now row 2). Is there anyway to always return the top…
