-
How do I concatenate contact names from different sheets?
How do I add a contact name from a sheet to a cell in another sheet that has already other names? For instance in sheet 1, column 1, I have Person One and in column 2, I have Person Two and Person Three. How do I add the 3 names to another sheet in one cell? Thanks!
-
Formula to change the Health status of my projects based on data from two cells
I'm trying to get a formula that will change the Color dot in my Project health status field, based on conditions in two other cells. What I want is: If the "Project Status" field = Active or On Hold, AND the "Project Wrap Date" field is Today (7), change the Health Status field to a Yellow dot; or if the "Project Status"…
-
Copy/Move Row Automated Workflow Not Working
Hi there, I have two very basic workflows set up - when the "status" column of a row in one sheet is changed to "review", I want that row to be copied to another sheet. The second workflow is the exact same, but when "status" is changed to "complete" I want that row to be moved to another sheet. The workflows are not…
-
How do you filter for a specific word w/o it pulling in things that contain the same letters?
I've created a report to pull only tasks that contain the word COA, but it's also pulling in tasks that just contain that series of letters such as "coating", is there a way to make it clear it is exact word only in the filter or other trick?
-
Linking / Updating Sheets
Afternoon All - I have a slightly complex question I wanted to pose to the community to see if I could get some thoughts. I have two sheets that I want to have "talk" to each other. One Sheet (Master Sheet), is where our team spends their day looking for requests to come through. In a second sheet (Change Requests Sheet),…
-
What is wrong with this formula?
I'm trying to change the status based on % complete column: =IF([Percent Complete]@row = 1, "Complete", IF([Percent Complete]@row = 0, "Not Started", IF(AND([Percent Complete]@row < 1, [Finish Date]@row < TODAY()), "Delayed", IF(AND([Percent Complete]@row < 0.5, [Finish Date]@row <= TODAY(5)), "At Risk", IF(AND([Percent…
-
IF statements formula
Hi, I have made this formula to sum number of actions happening in each month: Everything works fine when the dates is in the same year: If for example the first date is in year 2021 and the rest is in 2022 I get a strange number back: Formula for January: =IF([Month 1]@row = 1; COUNTIF([Year 1]@row; 2022); "") + IF([Month…
-
Trying to access an Ancestor cell (mostly grandparents)
I have struggled grasping how Ancestors works. I have the data below. Each Store # has about 50 'steps' under it, with a few Children that have Children. I want every row to contain the store number of its top-most parent. So, the level 1 is easy enough, it's just the [Store #]@row. Works great. The level 2 is also easy -…
-
Count Ifs for multiple criteria
I want to count how many developers we have in a certain area based on two criteria, what team they are on and if they are onboarded. =COUNTIFS({US Digital Team Members Range 2} = "API", [{US Digital Team Members Range 1} = "Building Services & Analytics", {US Digital Team Members Range 3} = "Onboarded"], 0)
-
IF(AND(NOT(ISBLANK Multiple Conditions?
Hello all, I'm having trouble nesting the IF(AND(NOT(ISBLANK formula with multiple "ANDS" If the Provisional Requested Amount column is NOT Blank AND the Provisional Requested Amount is less than or equal to the Final Requested amount column AND the Provisional Requested Amount is over 50000, I want the cell to say…