-
Retrieve value from "Top Parent" when Ancestor level = 2
I have a project management sheet. CSYYXXXX is the header for the project name column Tasks is the tasks column - at the parent row, I just write "Tasks" and then there are child rows below that. Some of these child rows and another level of descendant rows. I want a column formula (to serve as a helper column for various…
-
How to add varying months to varying dates?
I am really having trouble getting a formula to work here. I've gone through a number of support articles, but I'm just missing something. I want a formula that looks at Date Contract Executed and it adds Months Until Expiration to produce a new Date of Expiration. I've got my date columns as dates and the middle column as…
-
#Incorrect Argument Set
Hello, I am having issues with a formula and am hoping that someone can help. I am trying to tie two separate columns (Project Percentage and Days Remaining) to automate a project status column. I am getting an incorrect argument set error. Not Started = Project percentage is 0% Complete = Project percentage is 100% On…
-
Automatic Phase from WorkBreakdown
Hello all! I'm modifying the Simple Portfolio Work Breakdown Schedule and having a little trouble. I like the way the Work Breakdown structure works but I'd really like an automatic way to track which Phase something is in. I know I could just add a column and manually select which Phase tasks and sub tasks are in, but I'm…
-
Column Formula Help - Helper Checkbox for Shift Entries
Hello Community, I am looking for some help with a helper column checkbox formula needed to support reporting of data to a dashboard and downstream formulas. I have four shifts (A,B,C,D) entering data points into a sheet, with the potential for multiple line entries occurring per shift per day worked (see example below). I…
-
Find and Replace Function in Formulas
Having the ability to find and replace items in formulas would be incredibly helpful and save time as we update certain sheets each year.
-
Calculating Next Monday, Wednesday, Friday
I'm trying to write a formula to calculate the next monday, wednesday, and friday following a particular date. The AI formula generated =IF(ISDATE([Start Date]@row), [Start Date]@row + (8 - WEEKDAY([Start Date]@row, 2)), "") using the example above; however, it generated an #INCORRECT ARGUMENT error. The expected results…
-
Formula to bring back the 3rd Friday of next month
I need to calculate the 3rd Friday of each month consecutively on a sheet. I am looking for a formula that will take the date of the previous line and spit out the next month's 3rd Friday, in sequence. Any help would be very appreciated! Thank you.
-
Locking in results from a formula
I have a sheet that each ROW is a monthly store visit. I have a column that counts the number of visits each store has and add that number to a unique store visit ID…. example Store 123 visits= 3 then the store visit ID would be: store123-3 Every thing has been working fine, it is great because you can always tell how many…
-
How if a box is checked it any point in the process it will mark it checked for that section
I have sheet that has many items on one that all have a similar process. If one is marked sold at any point (any child step) it will check all the sold for that particualr parent and children. This will stop the notification for that particular item. I do not want it to check the boxes for the whole column because it will…
