-
Smartsheet Workspace to excel using the connector
Before upgrading to the next tier (where the connector exists), I want to make sure what I want to do is possible. Can the connector pass an entire workspace to Excel, rather than individual files. There is a workspace that contains many gantt chart files and an easy to view row summary of each chart is wanted such that it…
-
Calculate Difference Between Latest Entry and Previous Entry (Dates)
Hello! We are collecting weekly meter reading data (Meter Name, Reading Date, Actual Reading) via webform. I would like to create a calculation in a new column (within the sheet) that automatically calculates the weekly meter usage based on the meter name using current and previous entries by date. *For each Meter Name:…
-
Resource profiling
I have a requirement where each task requires a % allocation profile instead of the standard flat % allocation throughout the duration of the task - is it possible to set this up? For example, a task is 9 months long: Month 1 requires 50% Month 2 - 6 requires 100% Month 7-8 requires 50% Month 9 requires 25%.
-
Charts From Drop down Data
I have a sheet which lists loads of data on one column there is a selection of option (open, closed, etc....) Is it possible to put a widget or chart on dashboard showing the quantity of each option?
-
FORMULA - Pulling Data from last row filled
H E L P P L E A S E I have 5 rows (children) of possible data input areas. All 5 rows may not always be used. In Column "M" a number of 1,2 or 3 will be entered. Based on this number, Column "A" of the parent row should reflect "Closed" if the last row containing data is 1 "Work in Progress" if the last row containing data…
-
Revision Control - Best Practice
With an AS9100 Audit coming up for us, many have asked if our Smartsheet templates need to be revision controlled. Does anyone have any insight on this they could share?
-
Timecard Approval by WEEK, not by line.
Hi Community! Relatively new to SS, so I am thinking this has a simple solution. We are utilizing the timecard template but need a weekly approval from management. As of now, I can only get approval request to work by row. I do not want the managers to have to approve each row of the timecard... rather, just one approval…
-
Adjusted Dates Based on the Time a Form is Completed
I am looking to have my automatically set due dates for projects adjust if a request is put in after a certain time of day via the Smartsheet web form. Currently I have a date column where I add a certain number of work days to the timestamp depending on the department that submitted the request that acts as a due date for…
-
Sharing a report but not the source spreadsheet
I want to share part of a spreadsheet with a subcontractor. However, I do not want them to have access to the full sheet. For instance, source data: A B C D E F G H Data to share with subcontractor. They also need to be able to edit/update columns A, B, C. A B C According to the help page, this is not possible, but maybe…
-
Links in templates that can create a link on creation to a set sheet
I have a request that may already be possible so if someone can assist would be great. If not possible I believe it would be a great new feature.! We create a new sheet for each of our manufacturing jobs from a template. When this new sheet is created we then have to copy link the first row of the job sheet into a WIP…
