-
Card View rearranging order
Hello. I have a sheet that I would like to use in Card View. In the setup, things appeared to be working as normal: I have parent and child rows, in the order that I wanted, and when I switched to card view the hierarchy of the cards was the same in both views. However, in my testing something has changed. Now when I…
-
Adding a last comment column into a sheet
Is there a way to add a column that updates with the last comment entered into the conversations from that row? For example: If I entered notes from a call that I had with a client "conversation went well, will follow up" that note would populate into a column on that same row labeled last comment or update. This would…
-
How to regain access to a sheet?
I was the administrator of a log sheet, and the owner was an employee who left the company. One day, the sheet was deactivated, and no one has access to it. How can I recover it?
-
Best way to manage multiple users
Hello, The company I am with has an enterprise license for SS. We have a task where we are storing updates on a spreadsheet, as they evolve, within multiple departments. This has created much discrepancy within the data. I would like to lock it down to about four people being able to enter updates while others submit…
-
Report for past due tasks
I'm creating a report to show past due tasks. I want the report to show tasks that: Are not marked completed and have a finish date in the past Are not marked completed and have a target date in the past I'm having trouble with the target date is updated to a future date, I do not want the task to show on the report if the…
-
Automatic WBS Numbering
We have a work around but it takes multiple helper columns and complex formulas. You need WBS numbering 1 1.1 1.1.1
-
Revert to previous versions of sheets instead of just the activity log snapshot
I just ran automation on an entire sheet instead of just the rows. I wanted to move tasks to a compact task repository, and it moved 364 subtasks that I wish it hadn't. Now, I have to go back and manually revert what I can. Luckily, most of the time, we upload comments and proofs to the parent tasks, which, because they…
-
Multi-row intake form
Hello , is there any way you can have multiple row entries in a single intake form?
-
Plan Asset Manager - will it capture orphaned assets already in the system?
Hi, I missed the memo on the addition of the Plan Asset Manager role, and just assigned our admin account this role today. I did some digging because we had a person leave recently who didn't transfer assets before she left, and now we cannot access these sheets/reports. When we deleted her profile, we thought we…
-
Dynamic View Not Allowing Temporary Sort
I have a dynamic view that is pulling from a report that contains two source sheets and does not have any default sorting. When I try to temporarily sort the DV by date, it loads and refreshes as if it is sorting the data, but nothing gets sorted. All of my columns in the DV are behaving this way. What is going on?