-
Multiple IF Statements -- Status Updates
Hello, I am trying to put together a sheet that reflects as a holistic "Status Update" depending on whether or not something has been "Approved", is "Pending", or has been "Denied". I attached a photo that shows what I am trying to get my sheet to reflect and what is happening with returned values. Here are the examples of…
-
How do I create a dashboard that shows the schedule variance.
In my project plan I have a target start and target end date to track the variance between the actual start and end dates. I added 2 more columns to calculate the variance by target start date - actual start date. Now, I'm stuck on how to pull this information into a dashboard.
-
Formula to flag at risk tasks isn't working correctly
The formula I have in the At Risk column is: =IF(AND([Finish Date]@row < TODAY(), NOT([% Complete]@row = "100%")), 1, 0) So I want it to flag the row if something is overdue and not complete. However, if you look at the two that are flagged red, they shouldn't be marked since they've been 100% completed. What am I doing…
-
Multi-Select & Automated Notifications
I'm trying to create an Automated Workflow for Requesting Budget Updates. We some times have to send out Update Requests for Monthly Budgets - obviously the number of months will vary client to client. My question is - is there a way (using Conditions, Formulas, etc.) that I can setup one Automated Notification that would…
-
Hide #INVALID VALUE or Display Alternative
Hello! I'm using MATCH with COLLECT to return a value based off the two criteria of an ID and Today's Date in an "Intake Sheet" populated from forms. This data will be populated daily and I would like to: hide #INVALID VALUE when there is no value or display something such as "No Data". =INDEX(COLLECT({DailyUnits},…
-
What's wrong with my formula?
I know the answer has to be something simple, but I am just not finding the answer. If the Favorites column has a check mark, then populate (the cell containing the formula) with the Initiative Project Name. Maybe I'm not using the right function? 🤔 It seems logical to me, IF this row has a check, enter this data from the…
-
Help converting a simple IF formula to a column formula
Can someone advise what is wrong in the syntax that is causing it to not be converted to a column formula? =IF([Inherent Risk Level]1 = "Low Risk / Minor", "1", IF([Inherent Risk Level]1 = "Moderate Risk / Material", "2", IF([Inherent Risk Level]1 = "High Risk / Critical", "3"))) Thank you
-
Index/Match IF certain year
Hi, I am trying to populate a separate sheet with the Projected Fees by year. For example, I would like to populate a 2020 column with the Projected Fees from 2020, matched to the appropriate Client. I have tried different versions of INDEX/MATCH but not working. I would like to INDEX the Projected Fee and the Year (2020)…
-
How do I set up a notification for a specific row that contains formulas
I have a row that consists of formulas that are changed by other rows. How do I: Set up a notification for just one row (not column)? Set up the trigger to recognize when the product of the formula has changed? (i.e. if the formula in a column adds up to 150 this week and next week it changes to 200, that is a change that…
-
Sheet Summary: COUNTIFS formula to count up completed tasks
I have a schedule sheet with nested task sections. e.g., Parent Row is called "Copy Editing" and underneath that are children rows for 15 book chapters with Task Names like "Copy Editing - Chapter 1", "Copy Editing - Chapters 2-3", etc. I want a Sheet Summary formula that counts how many chapter rows have a value of 100%…
