-
Is there a way to easily share Sheet with all "Assigned To" contacts?
Is there a way to easily add all the contacts from a Sheet's "Assigned To" column into the "Invite Collaborators" field when trying to share the Sheet?
-
SUMIFS Cross Sheet Issue
Hello Everyone! I am needing help with the SUMIFS formula for cross sheet reference but when I enter multiple criteria, it returns a value of 0. What I am trying to accomplish is a sum for Sheet-2 based on multiple criteria from Sheet-1: Criteria from Sheet-1 * Job ID* 216116 * Cost Code ID* 7 * 15 * 16 Sum Range: Act.…
-
How to create a future date based on a date in another column?
Hi, I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days. Thanks! Keren
-
Creating different sheets based on one main sheet.
Hi everybody, I need to create separate sheets containing different information from one master sheet. But I also need to configure this in a way that if a new row is added to the master sheet, it will automatically be added in all other sheets that I created based on the master sheet. Any help is appreciated!
-
Date and month, linking cells
Hi there I'm linking cells from numerous sheets to one specific. Most of the cells are containing dates. When linking, I have realised that month and date have switched places. Not all dates/cells, but in some cases. See below example. Original work sheet: 03/06/19 Linking work sheet: 06/03/19 I've double checked the…
-
Notifications Not copying with sheets
Hi All, I have been having an issue since Friday when I save sheets as new, I receive an error that the sheet was copied but the notifications weren't. Is anyone else having this issue? I submitted a support request a couple days ago with no response. Thanks, Brooke
-
Linking sheets through dropdown box
Is it possible to create a dropdown box which draws it's items from the primary column of another sheet? I am putting together a system for managing the data related to my staff members including workplans, professional development and reporting. On each sheet I would like to be able to ask the staff member to choose their…
-
Web form submitted child rows - how to sort them into place?
Good afternoon, I have a sheet where we are tracking time allocated to various projects. Each web-form submitted project is then given a parent/child relationship with the child row being the submitted info and the parent being the summary view of all the children by the same project name. However, when I try to sort new…
-
How to force a sheet to fully recalculate via the API
Hi there API Developer community, I wish to use the API to force a sheet to recalculate. Currently, we use a report that shows just the first row of every one of our 50 or so project sheets and then we manually copy a new value into a column on that report that we have put aside for the purpose. So, once a value like…
-
Left panel menu
I liked the tabs on top of the sheets. I could put them in whatever order works for me. I don't mind the "left panel menu" that we now have instead - but I DO NEED to put the list of sheets in the order that makes sense for me! Every time I need to open a different sheet, I have to scan up and down the list of 20 sheets,…