-
Control Center Automation Ability to Trigger Document Sets Specific to Project Category
We would like the ability for Control Center automation to be configurable to trigger different document sets based on the category selected in the project intake sheet. For instance, if the new project request is Category 1, we would like to trigger a set of reports and sheets specific to Category 1. If the new project…
-
Programme Status based on %complete
Hi There, Apologies if this has been addressed elsewhere, I could not find anything similar. Are you able to status update a programme so to update % complete and the resequence the programme task to start after the today line?
-
creating mid-task lag?
In construction scheduling, we often have weather delays, lag when subs are working out of town, etc in which we need to create a delay mid-task. i.e., contractor A starts a task on 1/2, is delayed until 1/9 due to cold weather than picks back up and completes the task 7 days later than originally anticipated. Is there a…
-
Parent Row showing on multiple rows in a report
Hi, I'm currently using a sheet with information about different projects and need to show a Parent Row on all the other different "statuses" assigned to different Subtasks of that same project, I already have a formula to show the Parent based on their children, but I would appreciate any help on this issue. Attached…
-
Link an entire column from 1 sheet to another
I know you can do this at the cell level, but is it possible to link an entire column? I'm trying to save the time of linking over 6000 cells and want the ability to grow as I know the numbers will be increasing over time.
-
Project Sheet - Static Finish Date
I didn't see a post about this yet, please post a link if this is a repeat issue! It seems like the default relationship between Duration, Start, and Finish is that when you update the finish date or the duration, the start date is kept static, the duration gets extended and the finish date gets pushed out. Is there a way…
-
Network Diagram (Process Flow) View for Sheets
Develop a new view for Sheets that displays connected tasks as a network or process flow diagram. Once you have identified the activities and their dependencies, you can visualize the critical path analysis chart (CPA), known as the network diagram. The network diagram is a visual representation of the order of your…
-
RFI Request for Information Template - can not find
I found the RFI Request for Information Template that I loved on Google so I signed up for a Smart Sheet account. Im logged in and search for RFI Request for Information Template- the search result is a "Status View Smart Sheet" not a RFI Template. See screen shot. Here is a link to reference page to RFI Request for…
-
Can I alter this formula to generate a date based off a deadline of the 4th Friday of every month?
As a form submits answers to my Smartsheet, the submission date is recorded under a column titled "Created." This information is submitted to a committee meeting on the 3rd Wednesday of every month, so I needed this formula to specify at which meeting date each response row will be considered. I found the formula below on…
-
Calculating how long a query has been worked on and how long it remains at particular statues for
Relating to this previous community query, I've got 2x similar queries.. I've posted it in that conversation but wasn't sure if it bumped it up the queue, so thought I'd post a new thread just in case it wasn't. I've used the formula @Paul Newcome provided in his post to tell me how long since the creation date the…
