-
Formula to count check boxes in row one of column
I have a questionnaire with multiple columns. Responses are either check boxes or comments. I want to summarise the total check boxes in each column. I can add a column and write a formula to total the checkboxes, but the error message "#1 or 0 expected" appears when the formula is in the same column as the check boxes.…
-
Merging inventory
I have an inventory I do each month and have a fairly simple question but not sure what is the best way to complete this task. I have 3 columns. ItemNumber, ItemName, and TotalQTY. The first sheet is what I actually have on hand in the warehouse the second sheet is what our system says we should have. So far very simple.…
-
Webform copy for someone other than the creator
The help center states "there isn't a way to have the web form confirmation email sent to the sheet owner or collaborators," however,the collaborator would like to an email that looks like the form and not a Notification which looks like the sheet. His reasoning is that he wants to print the webform which is vertical and…
-
Webforms for help requests - best practices
We have a webform created that our customers can fill out to submit help requests. What is the best way to disseminate this webform and make it available for them to fill out? I don't want to have to email it to them, but at the moment I don't have a space on a webpage to embed the link/form. Would that be the best way to…
-
Web Form
Hi there, I was wondering if there is a particular access level where someone can see and/or edit a web form without having access to the data behind the scenes? I'm asking because the person isn't computer savvy and gets overwhelmed easily but would like to be able to edit the webform since it will be used by her to fill…
-
How can I put a drop down menu that dynamically updates or adds another field?
How can I put a drop down menu that dynamically updates or adds another field? I am a Project Manager. In my Web Form I created a Project Name field that has a drop down list of current projects to choose from. After I select a project, I want another field to appear underneath it to give the end user another option to…
-
Download Sheet Access Report is blank
Good morning, I'm needing to review who has access to the various sheets and I've tried to download this report in Google (blank), Firefox (it won't let me even access the Account area) and IE11 (blank report). Help? Blessings, Loann
-
Please add these features!
I now use Smartsheet as a huge part of my day-to-day work, I manage around 30 sheets at any given time (through mine and my boss' accounts). So there are a couple features I would really love to see added (and maybe I'm not the only one). -- Ability to lock comumns in a report - I need users to be able to see certain…
-
Enhancement Request: Choosing which task to display on Agenda
Hi, A great way to improve your existing features regarding Sync with Google Agenda (or even the regular Agenda view) would be to allow the user to check or uncheck the tasks he wants to be synced, and the ones he doesn't. I use a lot of titles or categories for my tasks and subtasks but most of the time they are…
-
Question regarding lag times
I am using predecessors in my spreadsheet and need some assistance with lag times. For example, one task is to sign the contract with the meeting planners (we do that in November)--that's line 12 in my sheet. Our first payment is not due to the planners until June of the following year. If I put line 12 in as the…
