-
Mail Merge with Google Docs: combine into one file
I'm doing a mail merge using Google Docs, which works fine except when I try using 'combine into one file'. I've seen a previous discussion where the pagination was an issue but mine is fine except it changes the font! Can anyone tell me where I'm going wrong? Thanks!
-
Formulas Not Autofilling With Form Submission
I'm having some issues with a formula that refuses to autofill with a form submission. The form is submitting new entries at the top of the sheet and I have two cells below it that contain the formula. According to this help article, it should be autofilling the formula into the new row. What has been driving me crazy was…
-
Can I change tasks visibility in a shared smartsheet?
Hi, I am trying to find out the best way to work with smartsheet in a particular scenario. I have project smartsheets that outline project milestones, and tasks within. This sheet is shared externally to my team for collaboration. In many cases, some of the tasks might drive subtasks, or small actions that the internal…
-
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.
-
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…