-
Register and calendar integration
Hi, I need assistance in creating a calendar which will show the number of locations where material deliveries will happen (5 locations) over 24 hours - 365 days a year. The idea is to then create a dashboard with the form and calendar and share it with the senior members of my team so that they can book delivery slots by…
-
Dashboarding projected annual revenue
I am trying to dashboard my annual projected revenue. This will factor on the amount of the job and the expected completion date of the job. I know the scheduled job date and the expedted amountof time it takes to complete a job so it seems like this is doable but I cant seem to figure it out. I have a sheet where I make…
-
Functions and Formulas
Hello, I am trying to write formula to calculate difference in BASELINE END DATE to actual END DATE =[Baseline End]58 - [End Date]58. Now I want to compensate for RAIN DAYS but receive UNPARSEABLE =[Baseline End]58 - [End Date]58+(duration)4 Where I missing it? Thanks, Gary
-
VLOOKUP & SUMIF
This discussion was created from comments split from: SUMIF value exists, leave blank if cells are blank (nothing to sum). User: Anthony12345678 Post: Having a similar issue. The Only difference is that my cells have the vslookup formula "=VLOOKUP(C3,Data!$D$1:$F$25, 2, FALSE)" in side them. When employees fill out the…
-
Nesting
I am not familiar with how to nest but I believe that is what I need to do. I have a column titled "Stage". The column has three different options. They are high likelihood, medium likelihood and low likelihood. I need to have a separate column that is either 75%, 50% or 25% depending on which likelihood is in the stage…
-
SUMIF - FORMULA CAN'T FIND A NUMBER STARTING WITH "0"
Hi, I'm trying to Sum total cost. But it doesn't recognize the number "00000013". Also, if I change the criterion to "13" and switch to another column with =RIGHT,2 formula, from the "00000013" column that would equal "13", it still doesn't work. My formula is =SUMIF({02. BUDGET TRACKER COST CODE}, "00000013", {02. BUDGET…
-
Using CONTAINS for 2 criteria
I am having a problem creating a formula using contains for 2 criteria. Here is my formula that pulls the information I need. =SUMIFS([Column2]1:[Column2]22, [Primary Column]1:[Primary Column]22, CONTAINS("hat", @cell)) I want to sum column 2 if the primary column contains "hat" and "gloves". I get various errors when I…
-
Trying to back into a date and also use duration
I have a construction timeline that has tasks that lead up to it. The top Due Date is when the project needs to be completed by. The Days From Open need to tell me when to stat the task. (ex. first task start 90 days from 1/3/20). I also want to add a duration of how long that "90 day" task should take to complete. Basic…
-
Calculate average durations between dates
I have an original sheet with hundreds of rows of information (Source Sheet) that I am looking to summarize calculations in to a second sheet (Summary Sheet), in order to feed in to a dashboard. Source Sheet has two date fields that I am interested in - lets refer to them as an 'open' and 'close' date. I would like to…
-
Formula Help??
I'm trying to set up a formula to calculate a Reminder status by days. I have a deadline date that is in the past, but it does not turn my status column to a "Red" dot, it remains green and I do not know how to add to this formula to make that happen. Here's the formula I have in place, and it works, but I need status to…