-
Text Join Columns with a row range
Hi there- I want to Join collect the Email column(Contact field) and the Palo Alto Additional Emails column(Contact field) together with the ranges of rows 47-49 The first part of my formula worked: =JOIN(COLLECT(Email47:Email49, Email47:Email49, <>""), ", ") But when I added in the second part of the formula it didn't…
-
How can I get a count of new rows created on two sheets?
=COUNTIFS({Created 2}, IFERROR(MONTH(@cell ), 0) = 5, {Created 2}, IFERROR(YEAR(@cell ), 0) = 2024)@cell
-
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.