-
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…
-
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!
-
List users based on criteria
Hi Smartsheet Community, I need to generate a list of names based on multiple criterias, can you kindly point me in the direction on how to accomplish this? How do I get a list of members in the Mgmt or Ops Team? How do I get a list of Managers with over 10+ years of experience? Appreciate your input! Thanks in advance.