Is there a way to set up a formula that will move project status "completed" from under one parent row to another parent row named "Completed project" once the project status has been selected as completed?
Automation like this need to be done using a third party tool, like Zapier (but not Zapier for this particular use case unless you are experienced with it)
Craig
Is this an enhancement that will be on the roadmap? Just curious if this is one coming. I would use frequently.
I would like this functionality also.
Hello- I am looking for a way to make every row return the same value as the highest level of its hierarchy (usually just children and grandchildren). I want it to report the top row in a column. In this example, I want all of these rows to return the value "Top Line" in a column.
I am working on an attendance tracker that counts the points "Occurrence" someone "Employee Name" gets for missing work in a rolling 12 month span "Rolling 12 Months?". I am attempting to use a SUMIFS formula to create a running total "YTD" of the points someone has accumilated, using the criteria of their name, in the…
I have a sheet that contains practice-name, practice-seq,and coach-id. I have somehow added multiple exact duplicates. there are 8500 entries so its hard to find them….is there a report I can run to just show eact dups?