-
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.
-
Count Ifs Question
Hi Community, I want to use the countifs formula on a column that has multiple values (Ex: Apple, Banana, Pear). The cell is not restricted to one value, so some cells have multiple of the 3 values. When I use the countifs for "Pear", the formula is counting cells that contain ONLY "Pear". Is it possible to alter the…
-
Impact/target Multiple rows within the same group
Is there a way to impact multiple rows using a workflow? If I select "No", on "remote access" Column, I want the system to populate "Yes" on "was report delivered" column and today's date on when was the report delivered. "This is already happening successfully on my end" However, I want to target rows 3,4,5,6 with the…
-
Automatically Update Grandchild Status when Child Status Changes
Hello, I feel like I'm making this formula much more difficult than it needs to be (I'm totally overthinking it!). Anyway, I have a sheet that has Grandparent, Child and Grandchild rows. When the Child status changes to "closed", I want the status for the grandchild to update to "closed" Does anyone know any easy formula…
-
Index Match function for children rows on two sheets
Hi there, I am trying to index match on data in the second level children rows from Sheet 1 to second level children rows on Sheet 2, and am getting this error messages. Screenshots are at the end. Screenshots: Sheet 1 (data reference sheet) Sheet 2 (pulling data from source source sheet into this sheet) If I try to use…
-
AVERAGEIF with an AND
I'm trying to find the average lead time for completed projects that were started this year and I'm having an awful time. Full disclosure, I'm not great a writing formulas. I can get the average lead time for completed projects. This works just fine: =AVERAGEIF({Status}, CONTAINS("complete", @cell), {Lead Time}) And I can…
-
Mid/Find Formula Help
I have this indexed @row info to a column named "AR" (Format will always be like this and no middle name). I need to split First two words to column named "Name", Split email to column named "Email" and split phone number to column named "Phone". FirstName LastName Email@email.net 888-888-8888 Split to 3 columns: "Name":…
-
Countifs with Distinct?
I have two columns, Column A and Column B. How can I check Column A for a condition, and then count all the distinct corresponding values in Column B for which that condition is met? Is there an easy way to do this with Countif / Countifs and Distinct? Thanks!
-
What is a formula that will return a cells value located in a table based on two criteria?
So i want to include an interactive element on my dashboard when my client will chose the borrow amount and the term from two dropdowns. Ideally this would lookup the table on the right and return the corresponding value to the pink cell. any help is appreciated
-
Index/Match Returns No Match but vLookUp works?
I have an index/match formula that is returning a No Match and when I try the Vlookup it is working. =INDEX({BE Job Intake Range 1}, MATCH([Project ID]@row, {BE Job Intake Range 2}), 0) The colunm in the lookup table is a formula result combining the values of two fields. Seems to work fine when I use the vloopup but not…
