-
IF/AND - reference another table to populate cells
Hi everyone. I have two sheets. The main sheet has information on a number of assets including columns Replacement Year and Replacement Type. The other sheet is an "indicative cost table" with Replacement Type as the primary column followed by each year 2026, 2027, 2028 etc across the top. The cost of replacement by type,…
-
Attempting to add similar values with Sumif
I have a sheet that could list the same values multiple times as they are being populated via a Zap from Google Sheets. So that I can find a true total value of the Job Name, I am counting the times that they appear on the sheet and then dividing the Total Amounts of Sale for a Job by the number of instances on the sheet,…
-
Pulling data based on most current entry and multiple criteria with other entries on same day?
I am trying to extract data from a sheet and summarize the most current data point based on: 1) Matching a reference cell (Sample Location). 2) Ignoring blank entries since some rows may have data in some columns but not others. 3) Accounting for different reference cells that have data entered on the same date. The below…
-
Duplicate Row
UPDATE: I figured it out :) Hello! I am trying to get a row to duplicate if one column meets certain criteria. So if the cuff size is listed as large we need to duplicate the row to let the vendor know there is an additional item to be ordered, which has a separate SKU and price, how would I go about doing this? If Cuff…
-
Copying a formula in a cell from one sheet to another
Hi all - We are working on creating some task integrations and one of the items we are working on is when individual team members have special custom tasks for clients that deviate from our standards. We have one master sheet that populates through workato integrations with NetSuite pulling in key project data through…
-
SUMIFS formula that includes a checkbox condition
Hi everyone, I'd like to sum all cells in a column that are (A) in a parent row (B) have a certain name in the Producer column. I've inserted a checkbox column (called "Parent") with a formula to check the box if the row is a parent row (which works) but I can't get the SUMIFS formula to work. I've pasted the two I've…
-
IF (AND(MONTH - with payment due date and payment frequency
Hi, I struggle with this formula. Do you have a plan ? I want to calculate the amount depending on the payment frequency, f.e. yearly, half yearly, quarterly, monthly Hope you can help 😃
-
Formula for new column to get a hierarchy view in report
Morning, I am working on code to get some type of hyerarchy view in a report I added the below code and it is just coming up as blank I spread the code out a bit so you could see what I was trying to do, where did i go wrong? =IF(CONTAINS(0, [Task Level]@row), [Task Name]@row, IF(CONTAINS(1, [Task Level]@row), "--" + [Task…
-
Can you automate 2 requests for update in same row?
I am trying a workaround to ensure stakeholders are completing all the fields in a request for update automation. We have two party's that need to fill out the same row. I created a form with required fields for the first party. Then I created a workflow so that when a trigger is met from the form, a request for update is…
-
INDEX MATCH MATCH where the cell is not blank
Hello, I have a unique situation where I cannot do a standard INDEX MATCH MATCH. We have a spreadsheet like the simplified version attached. I'm trying to grab the data where the name matches on the left and the date matches on the top. However, since there are multiples of the same name on the left, I only want to grab…