-
Maintaining a date value through a formula
Hi, I am using a form to collect an employee Title and the start date for that employee. There are three different titles, and a different columns to collect that date per title (to allow us more instructions in the form that is being filled out). Ideally I'd like to keep the start date separate for each title. However,…
-
Formula to add additional year or years to a date referencing another column in the Grid
We have about 17 different training activities that we track for each employee. Upon completion of the training we enter the certification date for that type of training. Most of these certification expire after1 year, 3 years, or never (one time certification). I'd like to be able to use a formula to add either 1 year, 3…
-
trying to convert a row to column formula using IFERROR
using NETDAYS to calculate days between dates, and an IFERROR to have Blank populated. This works in the row just fine, When I try to convert to a column formula, I add @row to the cell and it becomes #UNPARSABLE. Before adding @ROW tried to convert to column formula and get the following. Help!!!! formula that is working…
-
Text to Date with variable month/day numbers
I have a data source that is exporting date values as text strings. To make it worse, it is using M/D/YYYY as the format. This means that I have getting dates like this: 5/1/2022 5/10/2022 10/1/2022 10/10/2022 I am familiar with how to convert a MM/DD/YYYY string into a date, but I'm not sure how to adapt the formula for…
-
Need a solution for a Match Contains function
Hello! I have a row of months and I just need to return which position in the range of cells contains a month of the year since those cells also contain additional text. Basically, if my consecutive cells are "January - In Progress", "February - Complete", "March - In Progress" I need a match that looks for which cell…
-
Roll-up Costs of Grandchildren
Good Afternoon- I used a formula to roll-up costs that were tabulated in a separate column with: =SUM(CHILDREN([Labor Total]@row)). Unfortunately, this only sums direct children of any given row, it works fine for 2 levels. It does not sum "grand children" of rows that multiple levels of hierarchy beneath them. Any…
-
Auto create unique IDs for both Parent and Child Rows for Test Scripts
Help with logic for Test Script auto creation of the Test Case ID (Parent) and Step Number. Since this is Parent / Child the Column properties for auto / number system will not work. Step Number: I created formula to auto generate step number ID by looking at the Step Details column and if the cell in row has any text/data…
-
Countifs formula
Hi, I am trying to count the number of cells that have CX Planned value on the reference of CX Status Column and at the same time CX Month reference should be dated as 03-01-22, below don't seem to be working, when i do separate countif formula they work but of course don't give what i want. What am I missing here?…
-
COUNTM / COUNTIF Confusion
Hello! I have a cell group that contains multiple pieces of information (from a drop down in a form, allowing for more than one choice) that I want to count and add to a report, and eventually a dashboard. An example of that information is below. What formula ia best to use to extract this information in the following…
-
Possible Issues with My formula
Good Morning everyone, I am currently trying to set up one my sheets to be mostly automated. I have a column that is labeled "Ticket type", "price", "quantity", and "total amount". I have a IF formula set up in "price" column so if a certain ticket type appears it will populate the column with a Number. In This sheet I…