-
Is there a way to automatically copy filtered content from sheet A to sheet B daily?
I have a sheet (sheet A) that is my source sheet, and the content is updated frequently. I'd like to filter sheet A on a particular column, and copy the filtered content to another sheet (sheet B) to share with my users, automatically at a daily basis. Before copy, content in sheet B needs to be cleared. I tried to use the…
-
Import related data into Master registration sheet?
Hi all! I am making a registration form for students who will be attending a summer camp. Because they are minors, we need agreements (I am structuring these in a simple "check the box if you agree to the code of conduct" format ) from both students and parents. The catch is that students and parents may not be filling the…
-
Proofing- Previous Versions
Hello everyone, I have been using the proofing feature in our team for internal proofing. I have an issue where as soon as you add a new document version, the previous versions are no longer visible they sit loading. You can still download the older version you just can't see them on the proofing panel. This means you…
-
Do dashboards and reports count as 'sheets'?
Hello All, Due to the limit of 100 sheets per user on the business plan we often try to spread the sheet ownership between the licenced users. What I haven't fully figured out yet is whether dashboards and reports take up 'sheets' or whether your total owned sheet count only refers to actual sheets?
-
auto incremental's from form data
I am trying to make a column auto fill down based on the number in a column. So if column [# of Registers] shows 5. i would like the Register Hostname to populate out from USRETAMXT01 - Reg05 down the column.
-
Formula to check box if cell contains Date OR Text
I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to time (as a date is not always applicable to this particular field). How can I revise my…
-
My formula works fine with no errors, but no value appears. What is the issue?
I am using another sheet for the lookup_table. The other sheets basically has the currencies and the rates of each currency. What I want to do in the sheet where the function is; basically once a row is added and the currency has been selected, I want it to generate the value of the currency from the other sheet.…
-
How can my rows autofill the formulas when a new entry is generated through a form?
I have worked out several formulas in my sheet. Now I want them to be autofilled whenever a new entry is filled through a form. I don't want to drag them manually everytime there is an entry because I want automated workflow to follow. Also, if I drag a couple of cells prior to the forms being filled, then what happens is…
-
Legal projects/task management sheet
Hi, I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce. To track the work, I have created one sheet for the legal team to use, covering all main "legal work" categories and then broken down to sub categories, tasks and then sub…
-
Register and calendar integration
Hi, I need assistance in creating a calendar which will show the number of locations where material deliveries will happen (5 locations) over 24 hours - 365 days a year. The idea is to then create a dashboard with the form and calendar and share it with the senior members of my team so that they can book delivery slots by…