-
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",…
-
Formula help to JOIN results of LEFT formula down a column
I have a column of values, I'd like to use a Join function to combine all the values into a list, but first i'd like each of these values to be trimmed via the left function. Here is an example of the Left function I am using: =LEFT([ColumnName]1, FIND(CHAR(10), [ColumnName]1)) How do I integrate this into a JOIN operation…
-
Hiding #INVALID DATA TYPE with formulas using NETWORKDAYS
Hello, I'd love some feedback and advice on how to get this to work. I have Start Date, Due Date, Duration and Due in Days columns. For my Due in Days column I am using this formula: =NETWORKDAYS(TODAY(), [Actual Due Date]@row) For my Duration column I am using this formula: =NETWORKDAYS([Actual Start Date]@row, [Actual…
-
Using COUNTIFS and OR statement
You're all so amazingly helpful that I'm back. I think this is an easy fix for most, but I'm scratching my head. I have a column named Status with multiple drop down options, of which only one can be used. I also have a column named PMO that is a checkmark. I want to get a count of PMO flagged rows that fall within several…
-
Index Match Multiple Criteria across sheets
I am trying to create a formula that matches criteria between two sheets, then populates a cell based on the criteria's results. The goal is to use an index/match to populate the "fee" cell in the second picture based upon the client and service level. Could someone explain how to create this formula? Thank you.
-
COUNTIFS + OR - Forumla Help
You're all so amazingly helpful that I'm back. I think this is an easy fix for most, but I'm scratching my head. I have a column named Status with multiple drop down options, of which only one can be used. I also have a column named PMO that is a checkmark. I want to get a count of PMO flagged rows that fall within several…
-
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…
-
Formula Help Please - Sheet Summary
Hi everyone - I have a GIANT sheet I'm working with that contains our project portfolio. I need to add summary fields to capture Project Status (from a dop down field in a column) across 10 different Sponsor Divisions (also in a drop down field within a column). I can't seem to crack this one. Can someone help? I'm sure…
-
Can Only reference a total of 100000 cells (combined) from other sheets. Please select fewer cells a
Hi All I am a newbie to Smartsheet, been working on it for a few months only. I am getting this error. Google is not helping me much. Please can a good samaritan assist me in this forum? Thank you so much. Existing formula that I am trying to update =COUNTIFS({Archive Sales Stage}, [Primary Column]@row, {Archive BU},…
