-
Which count formula do I use?
Hi, I have two sheets. The first sheet changes daily the words passed or failed depending if the item passed or failed our process. On the second sheet I need a daily count of how many items pass and how many items failed. This sheet needs to updated daily depending on how many passed or failed their are. I've been reading…
-
Want to count number of instances in a column
HI There, I have one column in which I track the status of each row with a traffic light (Red, Yellow, Green). I would like to count the number of Red's, Yellow's and Green's in the column so I can use this information in a dashboard/portal to show the number of each color/status. I have triied a few things, but I am…
-
SUMIFS total for data within last 30 workdays
Hello, I've read multiple questions regarding getting a return of SUMIFS for a set date range. I however can unfortunately not seem to get my function to work. I am attempting to get a sum on the total number of orders done within a specific hour over the last 30 days. I have a form that feeds in data that tracks orders…
-
Sum of data between dates
Hi, Hope someone can help me, if this is at all possible. I have a request form that my users use to request ink and I would like to use a formula to show me how much we have used for each Ink type per month or during the last 30 days. Below is my sheet which when a user requests ink it auto fills a request date field and…
-
Is there a formula which can capture information from from a rolling 12-month period?
I need to set up some cross-sheet formulas to capture how many machines we have installed over the past 12 months, broken down by each month - however I want this to be a rolling metric which only captures the information from the past 12 months - is this possible using a Smartsheet function, and if so please could you…
-
Control Center: Adding new sheet to provisioned projects using Optional Templates, broken formulas
I have a new sheet I want to add to an already provisioned project in Control Center but all the formulas return broken. I have created the sheet in the blueprint and have saved it as an optional template. This optional sheet is linked to other sheets in the blueprint (it is a summary of data linked to source data - for…
-
How do I create a predictive balance formula?
I'm not sure if this is even valid/possible, but I'm trying to create an accounting schedule which foresees upcoming payments and reflects the balance after the transaction. This image is a practice sheet with fictional values. In theory, I'd want the formula in Balance to always take the previous balance and add it to the…
-
Combining IF Statement and IFERROR
I need some help. I have the following 2 statements that work well alone: =IFERROR([# Days Since Last Offer]@row, "Auction") =IF([# Days Since Last Offer]@row >= 180, "Auction") But I need them in the same formula. I want to return the work Auction IF the # days is 180 and IF an error is being generated in the cell.
-
2 SUMIFS NOT equal to 2 variations
Hello, I've tried the below formula but it doesn't work (instead of SUMIFS A AND SUMIFS B), This works: =SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], "<>apple") This doesn't work: =SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], "<>apple") + SUMIFS(pay:pay, [Code a]:[Code a],…
-
Cell Reference to Other Sheet with Column Formula
Hello Smartsheet Community, I have a question regarding cell linking, while maintaining a column formula! I am trying to reference a certain cell in sheet 'X' back to sheet 'Y' and then create a column formula in sheet 'Y' that allows for automation of information that is being captured in sheet 'X'. Is this possible? I…
