-
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?
-
Document Control Using Smartsheets
@Chris Mondeau thank you for your help in my original post. I thought I would re-post here for everyone else within the industry could share. Hi Team, I work in the construction industry as a joiner and as part my day to day, I received architectural plans. Is there a way to set up a Smartsheet as a Document Control…
-
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…
-
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…
-
Smartsheet-Outlook Integration
I love the way this add-in speeds up the process of updating a Smartsheet row with email text and attachments. One gripe, though, finding the row that I want is not simple since I can only select full Smartsheets, which may have a large number of rows, many of which are not currently active.. Am I missing something? It…
-
Control Centre - Batch Updating
I am about to launch my first control centre Blueprint and one thing I am wondering is what would be a best practice for recording notes at a program level. We have a status meeting that reviews the projects in the Blueprint Summary.. The client will pass on a tidbit of knowledge in the meeting and we will record a note..…
-
Calculating Days
Hello How do i get this formula to Calculating the numbers of Days when i select the date columns. e.g I want to select the dates and then it calculates the number of days from the two date ranges selected.
-
Partial match with INDEX(DISTINCT(COLLECT(
Hello, I need to collect a list of values from my source sheet based on a search field (cell) in my target sheet. I have a very large subset of data that I'm pulling from, so I've divided it into 6 sheets to increase the speed of the lookup. Currently, I'm using the formula: =IFERROR(IF(OR(LEFT([Lookup Value]$2, 1) = "A",…
-
Countifs statements for date fields that are in the past
Hi there, I am looking to summarize data from a master sheet for inclusion into a dashboard via a project metrics sheet. Within the master sheet I have an “Opening Date” that is populated when the opening date is decided. I want to populate the Dashboard with the number of sites that HAVE opened each month (past tense).…
-
Calculate number of days per month within a date range that spans more than one year
I have a schedule that spans (2) calendar years. I want to return the number of days per month included in the range. Since I use this result for billing purposes, I have a column per month and year of the schedule the returns the number of days in that given month/year. I am running into problems once I get to the same…
