-
One off Saturdays in Gantt
Hi all, I work in construction and use the gantt chart heavily to manage scheduling subs. I have a unique situation for my project where I may have to schedule work on a Saturday. Is there any way to allow a single Saturday, instead of opening Saturdays for the duration of project?
-
Jira Connector only allowing one project to one sheet
Hi, We have recently implemented the Jira connector for Smartsheet and this is working well in each sheet where we have a one to one relationship with Jira Projects. We have a single sheet which is collating all enhancement requests (using a web form as a front end) which will place enhancements into the relevant Project…
-
Schedule of Values
Has anyone created a sheet for Schedule of Values? Ultimately I am wanting to insert the project budget and tag the budget lines to the SOV lines. I can then go through and identify percent complete on the budget areas or on the SOV and it shows expected expenditures/profit. The best is if I have the budget and connect it…
-
Formula to copy the information of one cell into a different cell
Is it possible to use a formula to copy the information of one cell ( In this case the cell is under a date type column) to another cell (also a date type column) . For example, if my cell #1 under column "concept start date" is: 06/19/19 then automatically my cell #1 under column "Start" would automatically fill up as…
-
How do I calculate the difference between 2 dates?
Trying to track variable durations of past projects and simply want to subtract the start date from the completion date... depending on which format the column is in, I get various errors. Seems like I should be able to simply subtract one cell from the other, no?
-
Auto Functions w/ Update Requests
Hello, I am trying to figure out if there is a way to 1) automatically add a new child row once someone has completed an update and 2) send out a "report" of updates (children rows) with the update requests so the person who the task is assigned to can see their previous updates. As of right now I add a new child row…
-
Dynamically update form data
Looking for help... I'd like to update the fields on a form dynamically. Example: Use the system-generated Creation Date to calculate a "Delivery Date" 2 weeks in the future and display it on the form. I know I can do this on the Smartsheet but I don't know how to display it while the user is entering information.
-
Weather icon on calendar view
I have been using smartsheet for several years, and I would love to see on calendar view a weather icon for, al least, one week. Just like Microsoft Calendar. My projects depends on weather, so its pretty important knowing the forecast.
-
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…
-
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%,…
