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.
Discussion List
SUM Parent without Children?
I've been able to figure out how to SUM children under parents, but is there a way to SUM just the parent rows? For instance: NAME NUMBER Parent: 10,000 Child: 10 Child: 10 Parent: 10,000 Child: 10 SUM (Parent only): 20,000 I'd like to do this without selecting each cell if possible so it'll update whenever new Parent rows…
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…
"Edit Rows in Smartsheet" button not appearing in Gmail
I have followed the instructions below, but the button is not appearing in Gmail and it still only has the button to login to Smartsheet. Is there another step or setting I need to know about? How to get it: * Make sure that all Smartsheet accounts are set up under the users' Google Apps email addresses (users…
Outlook app
I'm trying to use the Outook app but am running into a few issues: * 1. It won't work on desktop versions of Outlook, right? * 2. I can't seem to be able to edit the "due date" * 3. Do you have to assign to the person's email address? Thanks in advance for any help!
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
Reports and Linking Sheets
Hi all. Right now I have a master sheet I use for recording sales leads, that I then assign to specific people. We have in-house sales reps that I've created reports for - they have access to the master sheet so no problems. The subcontractors however dont have access to the master so Im left to linking sheets - which…
Why Smartsheet ???
I am trying to establish the difference between Smartsheet and Excel (Office 365 version). What features does Smartsheet provide that online Excel does not ?
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…
Calculating Durations
I have columns in my sheet with "Departure TIme" and "Arrival Time" in the format hh:mm Since there is no "Time" Type for the columns, so I had to kep the Column Type as Number/Text I am looking for a way to substract these 2 columns to obtain the duration of the trip. Many thanks for any help
Is there anyway to use elapsed time in Lags like durations?
Such as paint cure times etc.
