-
Access values stored in cell history
Hi guys, my idea here is to use the stored information in a cell value. Let's say that the first time this cell was changed is important to me and I want to store this value in a different column in my sheet. I would then use a formula to get this stored information, for example: =GETCELLHISTORY([info], [position]) info:…
-
formulas
Im trying to calculate the remaining amount to be billed on a project based on the Job % of completion, factoring in the original contract amount, the deposit and remaining amount that is due
-
I need a formula to find the average of the Count of Training IDs
I have a grid that intakes via a form, training evaluation answers. Each row of responses has a TrianingID associated to a specific training. I have been ask to find the medium average if the number of responses received per trainingID It needs to be a column formula due the new TrianingIDs populating as more and more…
-
Generate child rows from form and link to a specific Parent
I am creating a Grid for not. It will be used as a form for the data entry aspect. And the primary viewing choice would be calendar. Now given that, I initially started with a template, and then just discovered, I don't like the way it works. Below is the template I pulled. The last 2 records are what I entered via the…
-
I need collect to compare my criterion (@row data) with my criterion range (a referenced column)?
I've been working around collecting data from multiple sheets with help from this community, and I've run into another snag. I'm trying to pull data from a referenced column with a matching location name @row. It seems like a simple problem, but I keep getting #INCORRECT ARGUMENT SET. =COLLECT({2024 All Projects}, {2024…
-
How do I join specific cells from multiple sheets?
The question seems simpler than the outcome I'm hoping for. I need to combine distinct project types from multiple columns on multiple sheets. I know I need to use Join, Collect, Distinct, and potentially others, but I'm struggling with making it work the way I want it to. This is what I have: This sheet will be duplicated…
-
Adding Days to a Date derived from a formula
Hi All, I am trying to add a Follow Up Date to my sheet, following a Submission Date. I tried: =[Submission Date]@row + 14 and instead of getting a date 14 days in the future, I am just getting the number 14 added at the end of the line. Both columns are set to Date Types. The Submission Date is derived from a formula -…
-
Extracting text from a multi-select drop down column
I have an intake sheet where one of the fields is a multi-select drop down list. The values in the list are NUMBERS; TEST NAME. I want to be able to parse out just the number into a separate column in the intake sheet as someone submits it, so there'll be a populated column of Test Code Intake that has the NUMBERS; TEST…
-
VLookUp Formula
Hello - I would like to use a VLookup formula to pull dates into a column of a sheet I'm working on. The scenario: Column 2 needs to pull in a date from the reference sheet for the same company of the row i'm working on. The company name may not be exact. Example: Sheet 1 - work in progress Column 1 Column 2 Company name…
-
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…
