-
Due Date is Past Due - Checkbox
I'm trying to write a formula that will "check" the checkbox if the Adj End Date is Past Due and the % complete is not 100%) I started with just the Adj End Date portion and have not added the percent complete to the formula. This isn't working... =(IF(TODAY() > [Adj End Date]5,TRUE,FALSE) I then want to do conditional…
-
Master sheets - why sheets and not reports?
New to SS. Setting up many project sheets and then want the high level info pulled together onto a master sheet. Videos I've watched say to create a master sheet and link data in from project sheets. Project management webinar I watched has a company that designs/fabricates/installs 10,000 signs per year (complicated…
-
Consolidated Update Requests
When we first had access to Smartsheet, we were able to view all of our update requests on one screen. Did that go away or am I just missing it. Is there any other way to consolidate that information?
-
Collaborator not receiving all alert emails
One of my teammates is signed up for two alert email notifications. He only receives one and not the other. We checked his junk mail to confirm it hasn't been going there and he has logged into smartsheet several times. I am stumped on how to solve this issue! He needs to get these emails!
-
Running Multiple Projects on SS
Hey SS Community, I am involved with a company that currently has no central data base overviewing all projects. I want to put a system in place where the PMs can manage their own projects. Also a system where the sales, quoting and other teams can oversee how the projects unfold throughout the project life cycle. I…
-
Prepopulate a webform - Automatic Submit
I'm able to populate all the fields in my Webform by including the field details in the URL, Is there a way I can automatically submit this webform ? I'm trying to get data from a 3rd party package across to smartsheets without having to dig too deep into the API side of things. Thanks in advance.
-
Product Portfolio Rollup Templates and Guide
I was looking around the Smartsheet site and watched a couple of webinars on Smartsheet solutions, such as the Product Portfolio Rollup solution. From what was said on the webinar, these are a group of sheets/templates that work together to create a Smartsheet system of project management tools. Also said in the webinar is…
-
New to smartsheet - Creating a document from several sheets of information
I am new to smartsheet and am self taught by using the youtube guides. I was hoping someone maybe able to guide me in the right direction. I am using smartsheet to create a log for new sample parts we need to test (product development testing). The log will contain a brief description, a photo, dates and also have links to…
-
Starting a new PMO with smartsheet
My company currently does not haave project management. I have graduated from school and have been put to the task of opening a new Project office within the company. We have a ERP system in the company but they do not utlitize it for what its truly worth. I have picked smartsheet as a third party software to use for my…
-
Question about the link from cell in other link
I want to make a link : There is one main sheet and a minor sheet. I want to link from the main sheet to the minor sheet. But if I add one column or row in the main sheet, the minor sheet will not update the new column or row? How to make tihs???