-
How do I bring back a blank cell on date column cells when there isn't a date
Can anyone help with this? I keep getting the #Data Invalid Type message. I am referencing one column to bring back the Month name in another. It works fine where there is a date but when the cell in the Test Start Date column is blank i get the #Data Invalid Type message. Here is the formula I am trying to use. Like I…
-
Adding data from template into program rollup sheet
I am hoping this is an easy solution, but Id like to automatically add data from a "template" into my program rollup sheet. That is, when a user uses the "Project Budget" template, Id like to automatically copy portions of the data from that new budget and have it copied into another sheet (where my program roll-up data is…
-
Sheet Automation to include the child rows
I am trying to send rows to another sheet when a column is changed the "Weds". The rows have children nested with them. It isn't working with or without the children though? I am not sure what is wrong?
-
Dashboard
Hi, I'm creating a dashboard for my HR department - I would like to break down how many assignments each division hires - I have a division column and an assignment column - also, I would like to include the columns that indicate that a hire has been approved and the approval date. Is it possible to display this…
-
Formula Question: IF, OR, AND Solution Maybe? Nested? Other Logic?
What formula would work when a certain answer is selected in Column A, its result would be 10%. If that selection in Column A holds true and you select a certain answer in Column B the return value is 20%. Until you have certain answers selected in Columns C, D, E, F and G, you have 30%, 40%, 60%, 80% and 100% respectively…
-
Aging Report
Hi there, I am developing an invoice aging report and created an Aging column using =TODAY() - [Column Name]@row. I would now like to display the Payment Balance amounts in their appropriate Aging category (<30 Days, 31-60 Days, 61-90 Days, 91-120 Days, 121+ Days) according to the Aging column value. I’ve figured it out…
-
Project Plan - Excluding rows from the overall completion percentage calculations
I am creating a project plan that will be used for Lifecycle maintenance programmes. Each project plan will consist of up to 8 different work packages which will have their own task lines in. (See attached pic) This basic format will be the standard for all Lifecycle programmes. One of these will be for one of the…
-
What is wrong with my formula?
Probably something obvious... =COUNTIF((Position2:Position136, (CONTAINS("Medical Assistant", @cell))), AND([Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell))))
-
#Blocked when trying to delete column
I have a column "INACTIVE" that I'm trying to delete because I don't need it anymore. However, when I do, a different column that has a formula in it changes to "#BLOCKED." The "inactive" column is not part of the formula. I don't understand why deleting this column is causing this other column to be impacted. Below is the…
-
Need help with an ISBLANK AND statement please
Hi, I have an approval due date column and an approval date column and fa approval past due column - I would like the approval past due column to have a red circle if the approval due date is past due and the approval date is blank (this is because there will be a blank in the approval date column until it is approved) but…
