-
Automatically add Child Sum to Rows
Hi there. I am working on several sheets that have a column called "Hours" which holds an hour estimate for task rows. I'd like for their parent rows to have a sum like "=sum(children())" so I can see how many hours are estimated for each project. My problem is that while I can manually set this for the rows, these sheets…
-
TODAY Formula Constantly Changing Date to Current Date
Hi - We have a formula in a sheet =IF(Status@row = "Closed", TODAY(), "") That when the status at the row changes to closed, it was to add todays date in the Date Closed Column. However, it seems that it is now changing the date for anything previously closed to the current date. We need it to change it to the date when…
-
Formula with date column weirdness
Hi all! Happy Thursday. I have a formula that I created that is looking to calculate a number of cells that meet the specified criteria on a particular cell that inputs a date when a box is checked through an automation. What I am noticing however is that the formula is calculating items that are earlier than the specified…
-
If Contains formula.
I need to compare a column that contains only week ending dates to a reference sheet that has a date column that could be any date. And also look for the word 'yes' in a range of words. And also look for the word 'weekly' from a reference sheet. All this to give a return of 'Completed' if true, and 'Incomplete' if false. A…
-
Limit on workflows triggering other workflows (aka daisy chained autoamtions)
I have a "Re-Release" process that is very long and complex. At one point in the process, a row goes through a series of automations that trigger each other. These automations copy the row to an archive sheet, move the same row to a "Re-Release" sheet, copy the ID# to an "Previous ID #" column, clear the data in over 60…
-
This formula is working for other number ranges but not this one
Hello, Trying to do a count and this formula is working for all other number ranges, except for this one. Any ideas? Formula is this: =COUNTIFS([Risk Issue Factor Priority]:[Risk Issue Factor Priority], ">0", [Risk Issue Factor Priority]:[Risk Issue Factor Priority], "<7", Status:Status, "<>Complete", Status:Status,…
-
Merged: If Contains formula
This discussion has been merged.
-
Best Practices for overall schedule deviation
I'm trying to find the best way to show the overall difference between the date the case was Started and Finished. ideally it would organize all opened and closed cases showing an overall schedule/performance
-
Can I Reference Another Sheet in Table View?
I am trying to move more of my Grids over to Table View, but am not able to find a way to reference another sheet in Table View, aside from using the Dynamic Dropdown option, which is not what I need, since I'm working with formulas. Is this available in Table View? I haven't been able to find anything on it.
-
Operations Intake, portfolio & capacity management
I’m a fairly experienced SS user looking for advice or automation tips that have really transformed your workflow. We currently have an intake form submitted by our field team, which populates our master tracker. After submission, managers review these entries and assign them to team members. What are the best practices or…