-
Formulas always there
I have a sheet where people submit new items via a form. When this is done, my sheet includes three columns of set formulas. These columns are not on the form. For some reason they stopped working. What should happen: a new item is submitted, these three columns are included and automatically calculate what I need What is…
-
Sum the rest of a column
Hi All, I am trying to sum the rest of a column (see below). This is in the creation of a a blueprint workspace, so there is no data in there and so please ignore the divide by zero errors. I have 2 sections for project costs, one for labour costs which is based on a very simple salary*timeframe formula, and then a second…
-
If, then Formulas
Hi there! I am trying to create a formula for the following scenario and i've been unable to figure it out If Status Column is "Complete", Mark as Green, IF Status of Column is NOT Complete, then apply the formula =IF([End Date]@row < TODAY(5), "Red", IF([End Date]@row = TODAY(5), "Yellow", IF(AND([End Date]@row >…
-
Blueprint SheetSummary Formulas
In the Blueprint project plan, there are Sheet Summary formulas, providing the 'Category' & 'Initiative' from the Project Metadata sheet. See below: =({Project Metadata | Category}) =({Project Metadata | Initiative}) I need to add a new SheetSummary formula in the blueprint project plan to pull in the 'Workstream' from the…
-
Linking Formulas to Reports
I am currently working on pulling engagements/deliverables and other important information from all my projects into one consolidated program level dashboard. An example of what I came across, I can create a report where I pull all the tasks at risk across my project schedules and it is very easy to add a schedule to the…
-
I have a column formula applied to a Status Column, however it is not applying to one of the rows.
The column formula is: =IF(Progress@row = "Complete", "Blue", IF(Progress@row = "Upcoming", "Green", IF(Progress@row = "Ongoing", "Green", IF(Progress@row = "Commenced", "Green", IF(Progress@row = "On Hold", "Yellow", IF(Progress@row = "Discontinued", "Red", IF(Progress@row = ".", "", IF(COUNTIF(CHILDREN(), "Blue") =…
-
Remove numbers if answer is text
Hey Community, The below spits out the answer : TBC60. As the milestone date is 'TBC'. Is there any way I could get SS to add nothing if the answer is text rather than a date?
-
How to count the number of photo shoots, not completed, by brand? COMPLEX???
Trying to get the summary of the amount of photo shoots from one column, not checked completed from second column, and sorted by the brand by third column. So three columns. (Brand column with specific brand) + (OW Shoot Date column) + (Photo Shoot Complete column) = Total shoots by brand.
-
Countifs formula: Counting "MacBook Pro" Instances
Hi there, I need help with counting Asset Models by Keyword and by office location. Goal: I want to sum all Asset drop-down options that include the term "MacBook Pro." Metrics Sheet: Reference sheet: I'm currently getting a zero in the Austin column on my Metrics sheet for "MacBook Pro," even though it should show a count…
-
Index formula referencing a metadata sheet, how flexible is the naming convention for the range?
I have several different sheets referencing the same metadata sheet. Should all of my different sheet formulas use the same naming convention for the range? Or can they reference the same range but with a different naming convention with in the different sheets? I hope this makes sense. I have a couple of different people…
