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.
