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 September 2015
Discussion List
smartsheet security certificate not recognized.
I keep getting this message, where chrome reminds me the certificate is not valid. How can I get my Mac/Chrome to recognize smartsheet? I have similar problems now with other items too - apple store, twitter...stuff I use rarely and don't care about, but I need to figure this out to use smartsheet. Thanks for the help!…
Can I assign a task in Smartsheet to two people?
Hello community, My company is on a 21 day team challenge of utilizing Smartsheet to our best ability. I am working in a project plan for a client and want to assign a task to two people instead of the usual one person. That way both people can receive notification that a task is due. Is this a possibility? Thanks, Brian
Two Separate Date Fields into one sum
I need to give per diem to employers for days worked for two events. Some will work one, some will work both. I have a formula that works great if they are working both events, but get the #MISSING OR INVALID PARAMETERS" message when only one event is worked. Does anyone know how I can get a column to return a "0" date?…
Dependency between multiple RYGG cells
Hi, Is it possible to create a complex dependency such that a task's status is derived from it's sub-tasks' status. i.e: Status Task AVG(ST1-4) ST1 R ST2 G ST3 G ST4 Y That way we could avoid manually updating task's status manually and also connect it between sheets. Thanks
Drop down menu in forms don't show the Symbols
How do you get the drop down menu in web forms to show the symbols instead of text?
Individual Task List Report (aka "Look Ahead" Report)
We have about 12 projects underway that are using Smartsheet. I'm planning to send each resource on the projects a "look ahead" report that shows all the tasks they are responsible to complete over the next 2 weeks. I've created the report. consolidating the sheets, but have two questions: 1) It looks like I need to create…
Enterprise video?
Good morning, I did a search in the online videos on demand, but didn't find one. I'm looking for a video that gives a fairly in-depth look at what the Enterprise features are and how this is of greater benefit. Our IT dept is concerned that they would need to be our go-to for help regarding Smartsheet, and I'd like to…
A Gantt Chart with Costs
Is it possible to produce a Gantt Chart with costs? ie as you add Parents & Children the Parents Costs row will total the Children Costs row Have tried various formulae but other than building the full Schedule then adding formulae to each Parent row it seems to be a long winded method of populating the costs. Can anybody…
Formula that references Drop down list and associated values and give total
Hope this is possible.... I have several projects with team members assigned accross these different projects. I want to be able to see the total hours each person has been assigned accross all projects. See screen image below. "Matt D." is part of a dropdown list of names. In this case Matt is assigned to 2 different…
Building A Sheet That is Agile Velocity Focused
It won't let me hyperlink a copy of it but here is the URL for those who trust I'm not trying to do anything scary. https://drive.google.com/file/d/0B8APP67r815BaVdmRkxrRlVKRDA/view?usp=sharing So this creates a gant shart that shows them waterfalling off one another (but only shows where they end and not begin) It also…