-
Lookup the text of a predecessor by starting with the predecessor #?
Here is what I'm looking to do… If I flag a task as being late, I want to look at its predecessors to find the blockage. What is the easiest way to do that? I'm sure that I will need row numbers in this solution. Let's say I have that covered (I don't). Once I have that ready. I can look at the predecessor #, go to the…
-
Pull info from another sheet based on 2 criteria
I'm trying to pull in hours to what I'll call Sheet 1 from Sheet 2. I have flexibility in the way I set up Sheet 2, but I need Sheet 2 to be able to have various employees use the same project number. This would be one option for Sheet 2: In sheet 1, I will have the project number listed in a column, but will only have the…
-
Formula Functions causing cell references limit error?
Hello, I'm trying to determine which FUNCTIONS I'm using in column formulas of a program schedule sheet that may be causing too many cell references so that I'm going over the limit of 25 million references (when I have around 3000-4000 rows). Most of my formulas just have @row formulas, but I don't know what some of these…
-
Can you use the HAS function in a COUNTIFS formula?
Based on what I read about HAS Function in the Formula Basics (HAS Function | Smartsheet Learning Center) I should be able to use HAS with COUNTIFS. When I try to use it in a sheet, I receive the error message: The formula cannot be generated because the HAS function is not supported in COUNTIFS. The formula I tried is:…
-
Combine results of multiple COLLECTs? Or alternate strategy?
I am trying to get a count of trainees in my app, each trainee has a unique "Member ID". A trainee is defined as meeting one or more of the following criteria: has a value of "Submitted" or "Issued" in the "Status" column of the "Reimbursements - Approved" sheet has the current grant year (e.g., "GYr 4") in the "Mentee"…
-
CountIFS w/Three Sheet References
I am trying to get a CountIFS formula to work that includes three sheet references and I get errors no matter what I do. I am trying to count the number of tasks with the isParent checkbox not checked, the Status equaling a specific value, and the Category also equaling a specific value. The values are represented in the…
-
Parent Marked Qualified and changes status of all Children relation
If Status on the parent is marked qualified it will fill all the tasks below for this section only qualified. Which will stop all the alerts. How do I make it so it only affects this drop down and now all the ones on the sheet. And have this same situation going for all the dropdown
-
Sort Formula issues
Hi, This formula causes a #unparseable and can't figure out what is wrong: =IF(Description@row = "Overall Project Risk", "0-00", IF([RAID Type]@row = "", "", IF(Status@row = "Complete", 7, IF([RAID Type]@row = "Decision", 1, IF([RAID Type]@row = "Issue", 2, IF([RAID Type]@row = "Risk", 3, IF([RAID Type]@row = "Action", 4,…
-
When a parent is marked complete how to mark remaining children tasks complete
I have a list that has many parents in the sheet and below that are 4 children tasks. Each have a due date. Not all will need all 4 tasks. How do I have it so when then parent is marked complete it will mark the 4 children tasks complete. This way it will not send notifications if overdue since they will be marked…
-
How to Assign People from another Contact Column
I want to assign people in a column to be the same as the contacts assigned in a previous column, unless the user overwrites the new assignment. I.e. if the Stage = "Step 2", the Step 2 Owner will be the same as the Step 1 Owner - unless overwitten to be something else. So far I've found that the "Assign People" automation…
