-
Simple RAG status
Hi all, I am looking to create a RAG status, based on start date of a task. Rules would be: If start date is over a week away, status is GREEN If it's within one week of the start date is YELLOW If start date is in the past is RED I also have 3 simple status options, so If status is set to "Complete" I would like the RAG…
-
Hidden Columns in Reports - edit, print, send dialogues
Hi. i have built some reports off a large sheet where i have chosen to show only select columns related to the function of the report. I have also hidden some columns within the report. Yet when i use the Edit, Print, or Send dialogue boxes, all the columns from the main sheet are shown. Including the columns hidden in the…
-
Developer needed....
I'm looking for a developer to help a business with a business / operations set up and on going support. We currently use Smartsheet and want to extend our use of it - manage projects, flow, contact with clients, contact with consultants.
-
All Projects Overview/Scheduling
I am looking for suggestions and what other users utilize for an overview of all current projects within Smartsheet to prioritize and schedule. A summary report with a Gantt chart is just not sufficient enough to see how things are going within the business on all projects and the resources. We need to be agile and…
-
Resource Allocation
Hello Smartsheet Team, I have been using Smartsheet for over a year now and my organization benefits greatly from Smartsheet functions! However, resource allocation is something that prevents us from moving forward with Smartsheet fully. There are 2 things that we struggle with: 1. Lack of option of flexibility in the…
-
Integrate with Microsoft Access
Does Smartsheet allow for integration with Access database tables? Is this something that a connector is needed for; such as Data Uploader? Will the integration work with older editions of Access or only Microsoft 365?
-
Integration with Oracle Primavera P6
Has anyone had any luck with using API's or exporting/importing Smartsheet scheduling projects to Oracle Primavera P6? We are using the cloud version of P6 and both it and Smartsheet technically have open API's so it should be possible. However, rather than recreate the wheel, I'm wondering if someone has already worked…
-
Using a master sheet to change multiple sheets
Currently, I have a project template that I use for opening a new location. Our company is typically working on 5 or more location opening projects at a time. When changes need to be made to the basic structure of the project plan (i.e. deleting a task, adding a task, adding a column etc.) this change has to be made across…
-
Percentage (%) complete formula
I'm using this formula suggested in another thread to calculate the percentage complete for particular tasks: =(Today()-StartDate)/(EndDate-StartDate) What I'd like to know is how to cap this at 100% because I don't want the percentage to keep increasing the further past the completion date we go. Any ideas?
-
Premium Feature High Prices / Locking out Small Businesses
Hello, Is anyone else disappointed in the pricing and the lack of availability of the Smartsheet Addons/Premium Features? The features of these premium addons are pretty badass and would be useful. I feel like I would use dynamic reporting (especially if they had date filters) quite a bit. Along with this, I use a lot of…