-
Error formula to also include blanks for zeros
Hi - I currently have a formula wrapped with the IFERROR to return blank if an error is calculated. I would also like it to be wrapped to return a blank for zeros as well. Any thoughts? Here is my formula: =IFERROR(COUNTIFS({OS}, OS@row, {Level}, "Unify", {Project Status}, "Complete", {Project Type}, "Database",…
-
COUNTIFS, OR with three reference columns
I'm trying to test for three conditions with a COUNTIFS. One column consists of status checking for "70", the next two columns are dates that must be populated or other functions will not produce correct data. Count If, Status =70, Actual Start = Blank or Actual End = Blank I've tried: =COUNTIFS({2020 Work Plan- Status},…
-
Adding cells until another cell changes
I am trying create a formula to add 2 cells until 2 other cells have data placed in those cells I want to add them.
-
Complicated Approval Workflow Question
I need some help with writing what I feel is a complicated approval workflow. Currently, we have a CapEx approval process that is done in Excel and requires approval from a Manager, Director, VP, and VP of Finance. If the CapEx is greater than $50K our President needs to sign off and then it needs to go back to the VP of…
-
Help using SUMIFS with MONTH(TODAY())
Help! I have gone over it several times and can't seem to find the error. This formula sums the value of Williams jobs that were completed in the 4th billing quarter (Contracts and Billing- Active Range 1 calculates the billing quarter based on the calendar date) =SUMIFS({Contracts and Billing- Active Range 4}, {Contracts…
-
How do i write the following formula
I am trying to write a If-nested formulas that works out the following. What i am trying to say with this formula is the following: IF the status is Complete and the planned end date is today or within five working days = Green IF the status is In Progress and the planned end date is today or with in three working days =…
-
formula to verify dates
I have a form running off a sheet containing separate date columns for start date and end date. Users of the form are accidentally selecting an end date that is before the start date. Is there a way to formulate an error message for when that happens? And/or... can someone help me formulate on the sheet for when the end…
-
Showing the start/end date in a project plan in multiple time zones
Hi, I am developing a project plan for a global team. I have built a project plan that shows the start and end times in PST but other team members would like to see when a task is going to be triggered in their local time zone. In MS Project I was able to create a column that showed the date/time plus 9 hours for CET, for…
-
How to use multi-select dropdown list as criteria for sumif/vlookup
Hey guys, thanks in advance for you help. I have three sheets that I am working with: a database (of sorts), a grid-form summary sheet, and sheet that contains attributed values. To simplify, I will only use a, b, c, and d as production point names and whole percentages as attributed values. The "database" contains unique…
-
how many days task took per specific month?
Hello, Maybe someone could help with formula preparation. Example: I have a task that lasts for several months (06.02.2020- 18.04.2020). How to calculate a numbers how many days task took per specific month (separately for FEB, MAR, APR)? Thanks!