-
Calculations of weeks not showing in whole figures
I am trying to calculate the dwell time for each project, by using the start date & a formula to change the date daily to todays date, however the final figure is coming up with additional decimal places, is there any way to round this figure down / up This is the formula I am using
-
Calculating Monthly Labor Hours From Project Sheet
Greetings, I am trying to pull labor hours by month from my project sheet. For some reason the below formula seems to work but it also attempts to calculate the values in the parent task which is =sum(children()). I know something is wrong with my formula below. I need to pull labor for each month and I am running into a…
-
If / Or Statement not working
I have a what I thought was a simple If / Or statement for calculating NETWORKDAYS in Ticketing sheet. Short explanation, when a ticket is opened it is assigned a SLA based on Priority (Critical=1, High=2, Medium=3, Low=4). While the ticket is open the Actual SLA is tracked by NETWORKDAYS. When the closed is closed the…
-
Date input - referencing multiple sheets/sorting by week
Hi, I'm creating master task sheets for each project/event, then other task sheets for each person with just their individual tasks. I have made it so when tasks are added to the master sheets, assigned to a particular person it will get copied to their sheet. I created a formula to automatically match/update the end date…
-
Auto fill a second column based on a drop down selection using a form
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates into a sheet. (This seems…
-
Help with COUNTIFS function with external references where first variable has multiple choices
Hi, I have a sheet with ranges identified as SUBJECTM and FLAGM. On my summary page, I have a list of all variables, with the column identified as Metric. In the main sheet, the subject field is a series of checkboxes with the ability to select multiple options (think : maths, english, french, art). I want to count the…
-
Netdays formula only on rows with a column value
Hello! I'm looking for some help with the Netdays formula. I am trying to create a helper column that tracks the number of days between a date column titled "Start Date" (when a project began) and a date column titled "Completion" (when a project is completed). My current formula, which is just a start, is this:…
-
Date functions in IF Statement
Hi, I'm trying to get the previous month and previous year via a formula. Here is the formula I am trying to use: =IF(MONTH(TODAY()) = "2", MONTH(TODAY()) - 1 + "/" + YEAR(TODAY()) - 1, "false") It works when I remove the -1 from the YEAR(TODAY()) - 1 part, but when I add the -1 back in I get #INVALID OPERATION. Any ideas?…
-
Is there an easy way to adjust the timezone on a "created date" column?
There is a sheet with webform that my team uses for task requests that has a "created date" column. The date/time is automatic, and 3 hours behind our actual timezone. Is there an easy way to adjust this?
-
How to convert the names to related emails
I have data in the main file and there are mixture of PM names and emails .I want to extract few of them from the list but the problem is since they are not same I mean mixture of email and Name not able to build a precise formula. Help in converting them to proper fromat before extraction.