-
Trouble with nested IF formula
I'm trying to "round" a value from one cell to conform to a series of selected values using a nested IF formula. The attached image shows the original value in cell [Column2]78 and the nested IF formula is in cell [Column2]85. Based on my formula, [Column2]85 should be showing a value of 164, but it's stuck showing 94.…
-
Nested IFs wont work
I am trying to auto populate a text/number field with the status of Pass, Blocked, Not Run or Failed depending on the status various child records. I have calculated the number of children per parent (Count Children Per Parent) and calculated the number of child passes, child blocked, child run and child failed etc.…
-
Track inventory movement in multiple warehouse locations
Hi, We would like to track inventory movement between multiple warehouse locations, there is no need to track stock value/sales, just need to track inventory movement between locations and the inventory balance Warehouse: Warehouse A, Warehouse B Item: Item A, Item B Current Stock: - Warehouse A, Item A: 15 - Warehouse A,…
-
Countifs with dates
I am trying to create a formula that counts the number of open reqs at the end of a month. The fields are in another sheet (call it Sheet) Fields would be req approval date, and offer acceptance date. I have helper fields created, but not using. I have tried, but think the blanks the offer acceptance date are causing me…
-
MAX COLLECT where one range has multiple values
Hi, I am using MAX COLLECT to extract from a sheet the most recent date of an event, based on a few criteria. One of the columns can have multiple values (as the source is a multiple value drop down). The current formula is =MAX(COLLECT({Date}, {Blank}, $[Primary Column]$2, {Section}, [S1]1)) where: {Date} = date in source…
-
formula to return what day of the week a date is?
in Excel this would be the formula =CHOOSE(WEEKDAY(A1),"Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat") Does not work in SS?
-
Formula to count # if blank or date in the future
Looking to count the total number of either blank or dates in the future - here is the formula that works to show blanks, but need to add is blank or todays date =IF(COUNT(CHILDREN()) > 1, SUM(CHILDREN()), COUNTIFS({Site}, BFS$1, {Department}, $Department@row, {VResults}, <>"NOT DETECTED", {RTW Date}, ISBLANK(@cell)))
-
I need help creating a formula that pulls information from two columns.
Hello All. I need help creating a formula from two columns on one sheet and pushed to the summary sheet/dashboard with the totals. The first column is a drop down menu for the order status (New, Processing, Billing, Completed, and Cancelled) and the second column contains a check or is unchecked. I am counting the drop…
-
Formula creation to auto-populate priority symbol
Hello, I'm looking for help with creating a formula. I'm trying to auto-populate the "Project Heath" column (red, yellow, green symbols) based off of my "Provider Start Date" column. If "Provider Start Date" is in 15 days or less from today, the "Project Heath" should be “red” If "Provider Start Date" is 16 days to 34 days…
-
Formula to calculate Monthly Total
I am trying to get the Total Amount for January only, but I keep getting 0. My sheet has dates up to Dec, and I created a helper column to filter months, but I can't get it to work. I used this formula: =SUMIFS([Total Amount]1:[Total Amount]17, Date1:Date17, IFERROR(MONTH(@cell), 0) = [Helper Month Column]@row) Any idea…