-
Index Match Formula help. Index Match of Health status of an activity into Sheet Summary
I have multiple sheets with the same columns (Health, Task Name, Start, Finish). Note that the Health column is a symbol (red, yellow, green, blue). In my summary sheet, I am using the following Index Match formula to search for Task A in Task Name column and spit out Health symbol. =INDEX(Health:Health, MATCH("Task A",…
-
Alert when tasks are planned to finish after a date in another task (deadline)
Hello all! I am trying to program a sheet to alert users when any finish date in the sheet goes beyond a specific deadline task in the sheet. I foresee it working like: User changes a start date, and several tasks down the dependency waterfall, a finish date gets pushed beyond the deadline task's date, and an error shows…
-
COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
-
TotalFloat with multiple phases
Hello, are there recommended best practices for handling dependencies when calculating TotalFloat, =TOTALFLOAT([Primary Column]@row)? In this example, Milestone 0 requires that Tasks 1-3 be completed and is a predecessor for beginning the next project phase. TotalFloat calculates values for tasks 5 & 6, but it does not…
-
Showing Sheet Summary Data in Another Sheet?
I am building SheetB to compare my budget by categories (data entered manually for now) against my actual expenses (entered in SheetA - totals for each category are part of my Sheet Summary data). Is there a way to reference those Sheet Summary totals in SheetB? Ideally, I will then be able to use SheetB to create charts…
-
Show my "next deliverable date" based on the child-parent task relationship?
Hi! I've been using the MIN and MAX children functions to roll up dates from child tasks, or sub-tasks, to the parent task. I also want to create a column that looks at the dates of each sub-tasks and grabs the one closest to today's date that has been marked as a deliverable so I know the "next upcoming due date" among a…
-
Can you make a sheet a sub-sheet of another sheet in card view?
I'd like to have a parent "card view" sheet, and multiple children sheets. The parent sheet would contain all of the cards in all of the children sheets and cards would be able to be edited on both the parent and the child sheet. This would be helpful for organizing cards by project, but allowing us to view cards from all…
-
Stumped on a formula: multiple criteria COUNTIF
I need a COUNTIF formula pulls results for a particular status result (i.e. Complete, In Progress, etc.) for all items one level down the parent/child heirarchy from a referenced parent cell. My team has multiple projects running in parallel that need to report out their progress. I was able to give a simple update for all…
-
Non-work Weekends For Only Some Rows
Hi Smartsheet-ers, I'm looking to organize a project sheet that has some task rows that work can happen on weekends, and some task rows that the work will not happen on the weekends. We work with two staffing schedules. A portion of the staff working on the project work on weekends, while the others do not. Does anyone…
-
Automate smartsheet data
Hi all, my first post on here We use smartsheet in our business for data and daily workflow. We manage dozens of employees who are getting assigned to do offline tasks, (they are not using smart sheet), usually with a client. We use smartsheet to collaborate between the managers, and we have the data in the sheets, but I…
