-
Plan change with error message
I accidentally upgraded to Business plan, then cancelled it near the end of the billing cycle, and rejoined as Pro plan. Since then, I can see all workspaces and sheets, can search and download sheets, but cannot open any sheet and receive a generic error message to all sheets. What can I do to resolve this? This is quite…
-
Regional date format issue in cross sheet reference
Hi, we use control center to roll out project toolkits, the intake sheet includes a start and end date for contracts. These dates pull through to a metadata sheet then to various other assets in the toolkit. To set up I right click the cell and select 'Link from cell in other sheet' and link to the relevant cell in the…
-
Updating template -> updates sheets made from the template
I would love to have the ability to make a change to a template that I created and be given the opportunity to select sheets that were created from that specific template to automatically update as well. For context: I keep track of ~130 employees training records. Each employee has their own separate sheet with all of the…
-
Changing series order in stacked bar chart?
I'm trying to show a summary of Projects, by both Branch and Status. I created the stacked bar chart below, but the Status series are in the wrong order and I can't find how to change them. The Status source column is a dropdown with the options in numerical order and the source sheet is sorted the same way, so I can't…
-
Status to red once the deadline is reached.
Hi everyone, I’m trying to automatically change the Status to red once the deadline is reached. I placed the following formula directly in the Status column: =IF([Ende]@row <= TODAY(), "Red", [Status]@row ) However, I keep getting the error #CIRCULAR REFERENCE. My understanding is that this happens because the formula is…
-
What happened to Default View?
Hello, I'm no longer seeing the default view option in my sheets. For example, we have a shared PMO Calendar that was previously set to "Calendar View." When I accessed it recently, I noticed that the default filter option is no longer available. Has this functionality been removed? We recently moved to Enterprise, but I'm…
-
How do I display the username of a modifier of a specific column?
I am attempting to display the username of a specific column using an automation workflow. I want for a user to be able to scan a barcode into column A, and for their credentials and time/ date of the barcode scan to be displayed in the next two columns. However, I want the credentials and time to be displayed of the user…
-
Date Based Automation Not Working
We have a sheet to help track when notary renewals are upcoming for staff and its a fairly simple process. We have a date column that lists the expiration date, a helper column that turns that into a total day count, status, and if an application was recvied. The trigger for this would be when that Days Until Expiration…
-
Cannot see sheets shared to me
I can no longer see all the sheets shared to me, even though I could see them all last week. I have requested access to them again and was granted 'edit' access and used them the same day. But the next day they have gone again. I have tried logging in with a different browser but still cannot see the sheets. Why is this…
-
Tasks with multiple start and completed stages before FINAL completion
Hello! I'm building a sheet to track multiple tasks. Each task (FILE) has different stages of completion (PROCESS/INTAKE, Research, Drafting, Reviewing and Finalizing). Each stage has an ASSIGNED TO contact and COMPLETED date. The Finalizing date will be the FINAL/END date. We want to track turnaround time per ASSIGNED TO…