-
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…
-
Require a roll up $ value to be inserted into a Form
Scenario: our Form has 5 different product categories that our partners will add $ values for applicable product categories. Unfortunately, our partners will submit the form will all of the other information without inputting any values. Thus, internal team will need to reach back out to partners to resubmit. It is…
-
Sheet Compare to highlight differences
The ability to compare sheets that have a similar layout and list differences between them. I know using Control Center and Global Updates to rollout projects and project changes will solve this issue but I have current/legacy projects that were manually created. It would be awesome if I could compare sheets in an attempt…
-
Merged: Please allow access to create formulas from reports
This discussion has been merged.
-
Formula to change the color of a task name or date cell, based on another date cell
Hi all! Theoretically, I'd like to state: If the cabling will be delivered, but it won't arrive within 14 days before the date of installation, then change cell color of these tasks below to indicate the need to order temporary/alternate cabling solution. I realize it may be too dynamic to only be set-up in conditional…
-
Left, Right, Find, Formula Help!
I need help creating formulas to split cell information. One cell contains indexed information in this string format: FirstName LastName Email@Email 888-888-8888 I need the formula to split to each of these 3 columns FirstName LastName Email Phone Thank you!
