-
Need Formula to auto populate todays date when box checked
Please share the formula that will auto populate the current date or "Todays Date" in the Completion Date column when the checkbox is populated in the "Done" field.
-
Adding Positive Parents
Hello all, I am trying to set a formula up that adds the sum of several Parent lines, but only if they are positive. Adding all parents under one banner i use the Sum(Children) however, I tried to add only positive parents by using a SumIf(Cell1:Cell5, >0, Cell1:Cell5) but in doing so only managed to add all positive…
-
SUMIF condition
Hi guys! I have to calculate average in my sheet and I will use: SUMIF / COUNTIF - COUNTIF formula is working. - SUMIF formula is not working, i am getting #INVALID OPERATION The SUMIF formula is (screenshot attached) =SUMIF([Assigned to in Region]8:[Assigned to in Region]136, "Sarah Mabiletsa", [Quote Prep Cycle…
-
LOOKUP Formula based on result between date range
Hello, I've tried to create a LOOKUP formula that will provide the "Approved Value" if the "Date Certified" calls between the period stipulated in "Period Start" and "Period End," without much success. Based on the screen-grab, only two values should be returned if the formula is successful. (I've manually entered these to…
-
Nested IF and
I trying to use to create a sheet that I will use to determine the status by comparing 2 status and then give an answer the e.g. If the status1 is low and status 2 is low the actual status should be low, I used the following IF/AND Statement and it worked fine: =IF(AND([Status1]3 = "Low"; [Status2]3 = "Low"); "Low"; " ")…
-
Adding Months to a Date
The Date formula allows addition but I get errors when I cross months by adding days or when I cross years by adding months. (Haven't tested years with adding days but that also crosses a month so I would get an error anyway. I need it to act like Excel and actually add a year for each multiple of 12 months in particular.…
-
SCC Nesting Summary Data
Is it going to cause any issues if I nest (indent a couple levels) data inside a sub-category, inside of a main category? (see attached img)
-
JOIN, COLLECT with MATCH
In Sheet 2, I want to JOIN and COLLECT a group of values from Sheet 1, separated by a comma. I have this figured out: =JOIN(COLLECT({AutomatedCourseCopy-CRN}, {AutomatedCourseCopy-CRN}, <>"", {AutomatedCourseCopy-UseinBCC}, <>"", {AutomatedCourseCopy-College}, CRN1), ", ") + "," I have a set of values in Sheet 3 that…
-
Gantt Task Completion bar based on dynamic % Complete
Is there a way to set a dynamic column to be the % Complete column for the purpose of setting the Task Completion bar? All help is appreciated.
-
Date calculation - work days only
I found the formula for date calculation (today's date minus 2 days is =[First Test Date]5 - 2 in my case). But I want to make sure it's calculating only work or week days. Is that possible? Thanks, Jennifer