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 2016 Posts
Archives for April 2016
Discussion List
Using Smartsheet report to populate website data
We are developing a new website for our company and want to incoporate some sort of link between some of the data we have on SS and displaying it on the website. Is there a way to do this? What is the best platform/back-end of a website to talk to Smartsheet? I've had a look around the SS website and cant really find…
How do I GET Sights?
Hi All I have contacted Smartsheet 'Contact Us' but have not yet heard back. What costs or implications are incurred if I want to 'get' Sights? Is this part of our package and I simply need ot activate it or is it an add-on that requires subscription payments? Thanks!
Creating Hierarchy Levels Automatically
Hi, I have a project plan with a number of hierarchy indents/levels. From what I can see we only have the option to expand or collapse all levels at once. We need to review the project plan at different levels depending on the audience. To help review the project plan at the appropriate level I created a new column called…
User Management
Hi All, Hoping someone can help me out, I am unable to see all users in the 'user management' view. If i go into the individual sheet i can see through the permissions users which have been set up, however if i go into 'user management' to delete them i am unable to do so because i cant see them there. secondly is there…
Workspace attachments
OK, this might be slightly embarrassing ... but where did the workspace level attachments go? And when? Craig
tracking Project by the hour
I have started a small project shedule for a job that will take around 72 hours to complete total but with multiple subs having to start and finish at certain times to hit that deadline. how do i change the calendar on the Gant to #1) just show me the 3 day assigned to the task #2) break each day down to a 24 hour time…
Feature request: Column for tracking time automatically
Smartsheet should add a standard column. Initally it includes a button syaing "start". When pressured on, a clock starts running in the background and keeps on running until one press the same button ( displaying the accumulated time for the task) or until the same user press another "start" button in the same or any other…
=AVGIFS Function Workaround
So there isn't an AVGIFS function currently in SmartSheet, but I still need to find a workaround. I came up with: =IF(AND([Project Manager]="Name",[Owner]="Name",[Project Status]="Complete"),AVG([Days to Complete]),"") However I am coming up with a "MISSING OR INVALID PARAMETERS error. I have pulled the averaging portion…
Dependency Settings
i am trying to build a construction timeline for a project. and i need to use different dependency time frames for different vendors in the same spreadsheet. for example: Permitting works on a business work week schedule. so Mon-Fri no weekends and no holidays. However the GC has agreed he wiil complete his work in exactly…
Update via Templates
Travis, One enhancement I would love to see is an ability to push out updates via a template. I hear rumors that it is magically possible via the API - can that functionality be brought into the UI? I am about to update about three sets of sheet (40 total) so that they can be presented well in Sights. I know that mgmt is…