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.
More than one column with the same name in Smartsheet?
I'm new to Smartsheet and tried to add more than one column with same name to my worksheet; got error message saying name was already used. Is there any way to do this? I'm tinkering with Smartsheet and think I may ideally need multiple columns with the same name (Responsible, Project Status) since there are multiple…
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…
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 ?
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…
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