-
Index Match with "Starts with" match criteria
I'd like to pull in a value from a separate sheet if that value starts with "xyz" (for example) and also matches a specific project ID. For example, if I have "xyz" as a value in one of the columns on spreadsheet 1. On spreadsheet 2, the value is called "xyz123." The two values have matching project IDs. How can I pull…
-
Join Collect with multiple criteria
Can someone help me with this formula? It will not work for the life of me. =JOIN(COLLECT({Current Loans Range 5}, {Current Loans Range 1}, "CASA"), [{Current Loans Range 2}, "Y"]), "; ")
-
Data containing parenthesis
Hi, I have data that contains a parenthesis. Is there a special way to reference data that contains a parenthesis in countifs statement? Here is the formula: =COUNTIFS(Category:Category, "System Maintenance (Post Go-Live)", Rating:Rating, "1") Any suggestions? Thanks, Matt
-
Summary Sheet/Report/Cards/?
I have no idea how to even approach this. I have played with using a report summarize some data using different views, but the formatting so limiting that I cannot get anything useful. I have a main sheet that tracks evaluations. For this summary I want to show just a small bit of data. I have columns that I want to use in…
-
Sheet Summary Formula for a Sum of costs for a specific date range
Hello, I would like to reach out to the community for help to create a formula to sum rows based on a date range. I think a sheet summary field is the way to accomplish this but I am having trouble and need assistance. Goal: Create Sheet summary fields: example: [March 2023]# Add the values in [New Projected Monthly Cost]…
-
Status formula - IF function
Hi, I am struggling to write a formula with the below parameters: If setup status and monitoring status is not started, then program status = Not started If setup status and monitoring status is complete, then program status = Complete If setup status or monitoring status is complete and setup status or monitoring status…
-
How to change Status (RYGB circles) based on State
New user here. Looking to include a formula that changes the Status (red/yellow/green/blue circles) based on the State. I continue to get an #IMPARSABLE message. Not Started=Red In Progress=Yellow Complete=Gree On Hold=Blue I welcome your input
-
Use of "TODAY" function
It is my understanding that if one types in the word "TODAY" in a date field, then each time the spreadsheet with that field is opened or saved, the date in the cell in which "TODAY" has been entered will be UPDATED to the current date. This feature is not working for me at all. I obviously am doing something wrong. Can…
-
Multiple Date Ranges, If Then
This formula works. My question is - if I want to add date ranges for 2021, 2022, 2023, etc., what is the syntax to add the other date ranges onto the end of this formula? =IF([Actual Finish]@row >= DATE(2020, 6, 30), [Actual Finish]@row <= DATE(2021, 7, 1), "2020") Thank you!
-
Need help with a formula
=COUNTIFS({Demand State}, [Primary Column]@row, {Investment Class}, "Grow", {Portfolio}, "P&C Claims", <=DATE(2023, 1, 1), {Demand Opened Date}, >=DATE(2023, 12, 31)) Can someone help me figure out why it's not working?