-
Using Auto-Generated Fields in Formulas Successfully
I have a sheet which tracks all a department's projects. We are making improvements which required us to create a new version of it by copying from a previous version (save as new) which meant that the auto-generated "created" date all the sudden became the date I made the new file, rather than the date the actual project…
-
Month Formula
Having some issues with the month formula popping up errors when being used as a reference for a range in the collect and countif/countifs functions The below formula produces an error =JOIN(COLLECT(Date:Date, Date:Date, MONTH(@cell) = 1)) The below formula returns a 1 even though every day in january is included in the…
-
Formula to Add Days to Calendar Date
Good Morning! So I was wondering if it would be possible to have a formula that would add 6 months (183 days) to a cell with a prepopulated date if a certain criteria is met. So managers will get a form and they will pick either "Yes" or No" for "Extend Vendor" and if they say "Yes" I want it to add 6 months to "New…
-
Max Function
I have a formula that finds and returns the maximum of a set of date cells meaning that it finds the latest date. It works fine if all cells are populated with dates but if one cell is blank it error out. This is the formula: =MAX([Due Date]1, [Family Member A Due Date]1, [Family Member B Due Date]1, [Family Member C Due…
-
SUMIF Not Equal To Formula
I am using this formula to Sum all values except for the ones assigned to "External"..It still adds these hours. What did I miss? =SUMIF([Resource Type]:[Resource Type], "<> *External*", Hours:Hours)
-
Expired Date code
So i recently create a new Cell called " Expired Date" what I'm trying to do in this cell is to show when a date has been expired , based on the Promised Date, but i found that if i left mi code just like this, But =IF([Promised Date]4 > TODAY(0), "Expired date", "-" i don't have a restriction. And i try this code, but i…
-
Date and month, linking cells
Hi there I'm linking cells from numerous sheets to one specific. Most of the cells are containing dates. When linking, I have realised that month and date have switched places. Not all dates/cells, but in some cases. See below example. Original work sheet: 03/06/19 Linking work sheet: 06/03/19 I've double checked the…
-
Index, Match, Parent
I'm trying to dynamically change a cell's value depending if a checkbox is checked or not. Directors of a project would like to know what stage a project is at and if that stage is on target or not. Where I'm running into trouble is the directors only care about the Parent Task and not the child tasks. This is what I have…
-
SUM Count of children Checkboxes
Hello, I am trying to add the children count of several columns but I just have a 0 as a result of a simple =Sum() formula.
-
Compound IF Statement
I am trying to determine a Classification when a Weighted Score is between two values. =IF(AND([Weighted Score]15 > 31, [Weighted Score]15 < 61, "B")) In this formula, I want to return a "B" when a Weighted Value is between 31 and 61. But I get Incorrect Argument. Can someone please help me. Dee