Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2015 Posts
Archives for November 2015
Discussion List
Linking parent & child "discussion icon"
Is it possible to link individual child "discussion icons" from a user(s) to the parent "discussion icon"?
Adding 'time" fields ?
Hello community. Wondering if there is the capability of capturing "time" in forms and sheets. I would like field engineers to log what time they arrived on site, then left via a Time field. I would then like the master sheet to calculate time spent on site. Any ideas? Thanks Stuart
Linking base price in master sheet to multiple rows in subordinate sheet
I'm trying to figure out a simple way to mass update a price list that contains many items with a similar base price tied to a commodity by linking that cell to a price in a master matrix. So, when I change the price in the master sheet, it will mass update dozens or hundreds of items in the linked sheet. Of course, you…
Duplicating/Copy a report
I need to make several reports based off 1 sheet. There will only be 1 change in each of the reports. Is there a way to easily do this, or do i need to build the report one by one? Thanks!! Vanessa
Finding the most recent date for one person
I work at an University and we are trying out smartsheet for keeping a log of when instructors have taught. In one sheet I have a column for the start date of the course, the end date, the name of the course and the instructors name. I am wondering if there is a way to pull the most recent date that an instructor has…
Importing an Excel file problems
I have an Excel xlsx file with multiple worksheets. I first worksheet is the one I am trying to import. and it has only 28 columns and 125 rows. None of my worksheets have more than 28 columns ofr data or formulas. When I attemp to import into SmartSheet tells me: "the file you are imports has a worksheet with more than…
Formula & Conditional Formatting Update in Reports
I have several smartsheets that have formulas and conditional formatting. These smartsheets are pulled into a summary report. The formula's and conditonal formatting do not update when opening the report. Each sheet must be opened individually in order for the formula's and conditional formatting to update.
Making a Web Form
Is there a way to create a web form and then track it? We have purchase/work orders and would like to create those PO's and then track them. What would be the best way to accomplish that? Thanks Dan
Signing smartsheet
Is it possible to place signatures onto the smartsheet? i have issued safety bulletins and toolbox talks to install crews who operate remotely andf i want them to prove they have read and undertsood the safety alerts and toolbox talks by signing the Smartsheet? I will be audited and want to be able to prove to teh auditor…
Overlaying calendars
Is there any way of overlaying calendars from 2 different sheets? What I'm trying to do here is to create multiple sheets (1 for each project) with all the same tasks but with different start and end dates. I would like to be able to see on the gantt calendar if the same task is happening on multiple sheet at the same…