-
Need Help With Tricky Formulas
For my projects (one per "column"), I have a column for "Deadline", "Remaining Hours", and "Networking Days Between Today and Deadline". Then there are columns that need formulas that need to calculate "splitting all remaining hours" evenly across months up to the deadline (and a column for August 2024, September 2024,…
-
Are the SUMIFS formulas working properly?
This formula worked yesterday in my sheet summary field and today is not working.. =SUMIFS([Remaining Work]:[Remaining Work], Category:Category, OR(@cell = "FC Support", @cell = "Maintenance & Reliability", @cell = "HR", @cell = "Chewy Leadership Academy", @cell = "FC Operations", @cell = "FC Systems", @cell = "Supply…
-
How to show drop-down selections in children rows on parent row?
Hello - I have a Parent Row that is an Item (Hardware & Tools) and children rows that have specific departments associated with each hardware/tool listed. Is there a way the parent row will automatically show every department that is selected in the children rows? Screenshot below: So on the hardware & tools parent row I…
-
Symbols Formula
Hi all! I am trying to set a IF forumula for symbols changing colors driven by multiple columns. =IF([BYT RELEASE DATE]@row = 0, "Red", IF([BYT ORDERED]@row = 1, "Yellow", IF([OPEN ISSUES]@row = 1, "Blue", IF(RECEIVED@row = 1, "Green")))) I can not seem to get the right syntex. Help is appreciated ☺
-
Help referencing checked boxes in another sheet
I am currently trying to pull information from an intake form directly into a project task sheet based on which boxes the user checks for individual project needs. The form has an automatic number field that sets the project request number, and the goal is to be able to simply add that request number to the correct cell in…
-
Index/Collect Formula
Hi there, I need assistance on Indexing/ pulling names from our directory on Smartsheet that reach a certain criteria. Formula I have: INDEX(COLLECT({DS-Name}, {DS-Office}, [Office@row], {DS-Title}, [Title@row]), 1 Example: I want to Index/collect a name that is from the "Austin" Office and contains the title "Office…
-
Error #BLOCKED
Buen día, se me está presentando el siguiente error en una de mis hojas. Actualmente en la hoja hay 2890 filas con alrededor de 90 columnas (la gran mayoría formuladas). Al intentar mudar filas a otra hoja para depurar la memoria sigue permaneciendo el error y las celdas aparecen "#BLOCKED". También, ya intenté quitar…
-
Reference Reports in Formulas (e.g. VLOOKUP) to sheets
It would be so nice to use a VLOOKUP to reference a report and pull what I need back to my sheet. Unfortunately, sheets can only pull from sheets.
-
Index, Collect, Contains, Or
In the source sheet that I'm referencing, there are 2 rows that contain the assignments, and I want both names. Here is the source sheet. So for the row in the target sheet where I am pulling the assignments for "Nursing Go-Live" I want both names (Greg and Darla): I want it to pull in the name for "Nursing Go-Live" that…
-
Reverse the Ranking Order
I am working on ranking clients based on revenue with the highest revenue being number 1. In the end I want to build a top 25 list that could change on any given day based on new data. I used this formula to rank my items: =RANKEQ([Lost Client-SUM-BI Estimated Annual Revenue]@row, [Lost Client-SUM-BI Estimated Annual…
