-
Mail Merge with Form
Hi all, I was searching on the Smartsheet community, but i could not find the best solution for my issue. Basically, in my company, everytime that a production finishes, i receive via e-mail the test results for the specific product. With those results, later on, i must issue a document to the customer with those same…
-
Scroll bars only work when mouse is on top of them in Chrome
In Chrome, the scroll bar works when you manually drag it but does not work while using the mouse. The manual dragging is a reasonable workaround but would be nice to be able to use the scroll around on the sheet without the scroll bar. This scrolling is not an issue in Firefox or Explorer.
-
Automatically copy specific fields from new rows in one sheet to another
Hi Folks, We have an intake sheet / form and a separate project sheet. Goal is to automatically copy specific fields from new rows in the Intake sheet (source) to a different Project sheet (destination) each time a new row is entered by users. When a new row is entered, we want to copy (as a new row) specific fields from…
-
How do I count how many cells are last month but not considered expired?
I am working on a sheet for currency of qualifications for our employees. I have the equations that will tell me how many employees are a month before they are due, how many are due this month, and how many are in the past but now I have to find and equation that will let me count how many qualification are only one month…
-
New Sheet -- Announcements Message
Hi, Is there a way to have a welcome screen or alert come up when a person goes into a sheet. I would like the sheets comments to pop up on new sheets or like an announcement on already existing sheets.
-
Sheet Security - Prevent Sheet Export and Printing
Is there a way to prevent sheet from being able to be exported and / or printed? We have multiple users accessing data with sensitive information on a sheet, however we wouldn't want those users printing or exporting that data, but still keep the access to edit the data on the sheet. Any thoughts?
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
Index/Collect/Match help
Hi I have a sheet that has epics, stories, tasks and I want to extract only the epics to another sheet. layout is simple Name IssueType Epic 1 Epic Story 1 Story Story 2 Story Task 1 Task Task 2 Task Epic 2 Epic Story 3 Story Story 4 Story Task 3 Task Task 4 Task I want the other sheet to only have Epic 1 Epic 2 thanks so…
-
Gannt chart start date does not match the date column
Hi, Pretty long project, spanning a bit over a year. I'm about halfway through it & the Gannt Dates started getting weird. In the image, Look at "Floors", predecessor 232. The scheduled start date column says 8/13, but the gannt displays the bar starting at 8/14. I dont know if this is related, but the scheduled start…
-
Formula/pie chart help?
I'd like to have a pie chart that shows a dynamic count of orders "pending/fulfilled/cancelled" of the last seven days. Ideally, there would be four separate ones for four locations (which will be presented on their personal dashboards), as well as a master graph that compiles the data for all four into one for upper…