-
Resource planning from date periods
Hi everyone, I have a problem which I'm really stuck on. On about a dozen schedules, there are hundreds of rows, assigned to 'ID's' (ID1, ID2 or ID3) that have durations from 1 to 9 days. I need to be able to predict resource capacity for those IDs, up to 6 months in advance, by week. In this example, the ID starts the…
-
Index/Match trouble with returning text value
My goal here is retrieve the Row 1 values(grey cell color) based on where the match cell (value = 14) in this case falls under. I added a row identical to the column header values to try to get this method to work but if there is a way to retrieve the column header for the top 3 highest values in a row please let know.…
-
Index Match Across Multiple Sheets
Hi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can get it to work for 1 sheet using =INDEX({Status},MATCH([Proj ID]@Row,{Proj ID},0)). Each sheet is for a different team,…
-
Displaying multiple "dates" in calendar view from same row
Good morning, I have date columns created for the 5 milestone dates that each task/row can be assigned. Is there anyway to get all Milestone dates (date columns) to display in the calendar view. I have set up color codes to help determine which is which but now I can't figure out how to get them all to display, looks like…
-
Crossing multiple data bases with a Partial Text/Number match
Hello all! This is my first question. I am building a tracker called "My Project Tracker" that takes information from multiple "master sheets" built by different teams with different purposes. See screenshot for example. "My Project Tracker" has the "Project ID" as user input, then it populates the "Project Name" using the…
-
Updating dates of completed tasks
I accidentally changed a predecessor for a task (actually added it to a summary task), and the system then changed all the starting dates for the indented tasks - ie, they all inherited this date. However some of the indented tasks has been marked complete, yet their start/complete dates changed. This was probably a…
-
Refund Tracking Smartsheet- Ideas or Template
Good Afternoon Everyone, I am overseeing customer refunds for our company. Our company requires customers to make a refund preference so when there is a refund due to them, we can deliver it to them as quickly as possible. However, because many of them do not make a preference the customer refunds are returned by our bank…
-
Column Formula to count (and sum) 'Waiting Days'
Hello, Can anyone suggest a way to manage this? I'd like to be able to count up time spent awaiting feedback from our client across various projects held in the same sheet. Essentially I need to be able to count the days between when a Version is sent and when Feedback is received. If Feedback is received on the same day…
-
Check for overlapping date ranges between sub tasks
Hi, I am looking for a formula that can check for overlapping date ranges between of the sub tasks on a project. In the screenshot below the project has several sub tasks and I need a formula that will identify any overlap between the dates on the tasks. I would like to prevent the use of references to cell numbers because…
-
Using Index Collect formula when there are multiple matches in the source sheet. (#Invalid Value)
Hello, My goal with using INDEX(COLLECT)) was to obtain information based on 3 different criteria, but in my source sheet there are multiple matches for the three criteria specified. What do I need to add to the Index, Collect formula to overcome this or do I need to use a different formula combination? Below is the…