-
Formulas and Data Rollup
Hi, I am in the process of putting together a sheet that logs the amount of production each day. As a bit of background we are an aggregate manufacturing and contracting business and what i am trying to do is have a sheet that tracks the amount of production of each product per day. I have created a sheet with all the…
-
Issues viewing Live Webinars
Hi all, I have been having issues viewing live webinars since the switch to the "GoToWebinar" format. I click the "join webinar" link that I receive via email and am brought to the webinar landing page. I can hear the audio (in real time) perfectly but my screen never refreshes so I miss out on the visual examples being…
-
Formula to include new data added to my sheet
I have set up a formula that works very well however it isn't taking into account new entries added to my sheet. For example my formula is on Row 1 under the column 'total' I then have other information in rows 2-15 so therefore my formula on Row 1 starts from row 16 to give me the total I want into Row 1. My formula in…
-
Excluding indented rows from being auto-numbered
I am using a web form for users to intitate developent requests and have set up column to auto-number each job request (P0001, P0002 etc.). The shop supervisor then adds rows below each job request to assign tasks to different team members and indents these under the main job request. Smartsheet assigns each indented row…
-
Improving the context of answers to community questions
Hi all, can I suggest that as there are lots of new users to the community since it was launched only a few months ago, that existing and new members add a little detail about themselves? That extra info should make it easier to see the context in which a question is being framed, so the answer is more appropriate?…
-
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.…
-
Why does smart-sheets forward you to a maintenance page for maintenance and then not forward you bac
This confused me as I did not notice the date right away. I went to breakfast and came back before I realized it was yesterday and the mainenance page does not automatically forward you back to smartsheets. I refresh the page and expect to be back online. Not super frustrating but a little dumb if you ask me. Can we adjust…
-
Google add-in: "Combine into one file" changes the orientation of the document
Hi there, Help! I'm using the SmartSheet add-in to print onto custom envelopes via Google Docs. I've laid out the merge fields so they print in the right spot of my envelope. The doc in Google is Landscape. When I create individual PDFs or Google Docs, they appear as landscape too. However, when I "Combine into one PDF",…
-
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…
-
REVERSE A WEB-FORM
I would like to be able to select a row and the information held in that row populate a web-form so that I can send the completed form to another user.