-
Predecessor Logic for a Specific Day of the Week
I am working on a project plan template that has a lot of dependencies enabled for dates, and many of them need to start or end on a specific day of the week. I have searched the community and see a lot of questions on this, but do continue to see that it has not been developed as of yet. I did try to search within the…
-
Apostrophes being added in front of numbers and column property changes to dropdown (data shuttle)
When I use Data Shuttle and I upload the source to the target, it is changing column property from text/number to a dropdown and adds an apostrophe before the number. I have 8 "discount" columns per sheet, but it only disturbs some of them. If I need to perform some calculations using those numbers, I can't. I'm not sure…
-
Average for both columns
I have a dropdown columns with several choices and each choice represents % complete. The idea is to get the Circuit % complete for 1st and 2nd circuits columns but also It has ‘N/A” that will not count. It only count the column that doesn’t have it. This is what I tried: =AVG(IF([1st Circuit Status]@row = "Assigned to…
-
Lookup multiple columns for text value and return cell value
I'm trying to figure out a formula to return the value in a cell over multiple columns. I have 10 locations consisting of various buildings for each location. Only one column will have text in it. The formula I have will obviously only return the text for that column and I cannot figure out how to repeat the formula to…
-
Combining rows with like names
We have a sheet set up with forms to allow for participants of a contest to #1 register for the contest, then #2 go to the second form to update their progress in the contest. Is there a way to combine rows when a someone submits the same name or email address, for easier tracking? Something that is automated to create…
-
How to subtract quantities from one sheet via forms to another sheet with total quantities
My issue is this: I have a master sheet with material types (A1,A2,A3 etc..) and total material quantities (#'s). The other sheet I am using is updated via forms. The form is used for distributing materials and requires a material type, and material quantity before submission. Once submitted I would like the quantity to be…
-
Average formula with error should give a blank cell
I used this formula below to give me the "DOC % Complete" but it is missing something. If the cell has “Cancelled” the Docs % Complete column should be blank but right now is giving me 50% =IFERROR(AVG(ISDATE([Design Circuit Recommendation Actual]@row), 0.5) + IF(ISDATE([Design Velo Recommendation Actual]@row), 0.5), "")…
-
How do I create an chart to show ongoing activity?
I use the following to surface data to illustrate submissions over time over a set period of time (set start and end date). This uses a metric sheet with the dates in one column and a function adjacent to 'look' for the same dates in my source sheet. How do I create it to capture ongoing submissions? IE no end date? How do…
-
VLOOKUP? INDEX MATCH? invoice amounts from sheet 1 into sheet 2 based on a matching #
Help please! I'm looking for the invoice amounts from one sheet transfer into another sheet based on a matching CAR#. For example: if CAR# FP2020-1 is listed in spreadsheet (B) then I want the invoice amount associated to populate into the $spent column in (A). I'm running into confusion because I can't figure out how to…
-
Can I save the settings for an update request?
I have a sheet with many columns When I send an update request most of the columns dont apply (they are for later in the process). This means I have to edit the uodae request and untick the columns I do not want to send. Is there a way to save the settings (unticked columns) for subsequent update requests from the same…
