-
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…
-
Trackers feeding other trackers?
Hello, What is the best way to "push" rows of data from multiple trackers into one tracker? Suppose user 1 and user 2 and a Manager use their own trackers. The trackers follow the same template. User 1 and user 2 must report progress from their trackers into their Manager's tracker. They must report entire rows from their…
-
Change status automatically when selecting % done
Hello I have searched through the Help centre (center!) and I can't find the formula (if one exists....) that will automatically select the appropriate value in the % done when one of 6 choices from Status is chosen. So when I select Not Started, I would like 0% to appear in the % Done, Started=25%, In progress=50%,…
-
Update Parent Row based on Child status
Hi! I want the Parent row to automatically change with the most recent Child Row status. I currently do this manually so I have to update the status in 2 different rows. Right now I have this: =IF(COUNTIFS(CHILDREN(), "Open") > 0, "Open", IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIFS(CHILDREN(),…
-
Gestational age
Hi all, I'm sorry if this has been asked before, I can't seem to find anything on it. I'm looking to calculate gestational age- the age of a fetus in weeks and days using the due date for reference and a typical pregnancy being 40 weeks. I have it in Excel but I can't seem to get it to translate over. Any help is so…
