-
How to provide a link to a specific row in Dynamic View for end users
When using Dynamic View I need to provide end users with a link to a particular row/record. Is this possible and if so, how can I accomplish this. So far the link I've added takes them to the table view which is unacceptable.
-
Generate Formula that identifies duplicate entries and notates most recent entry
I'm trying to create a formula that searches through the serial numbers in a column and if there are duplicates of a serial number, it puts a "yes" or check for whatever duplicate was entered most recently. I have a time/date of entry column, and I also have a duplicate entry column that counts up each time it identifies a…
-
Rolling budget/spend tracker
I have a bit of quandary with a recurring task, wherein I am tracking weekly budget allocations and tracking what is NOT spent. Currently, I have a basic sheet where my contractors/vendors upload a patient record, which is just a sign-in sheet, and I manually count the hours used. Each of these sheets represents a maximum…
-
COUNTIFS, HAS, and AND?
I am trying to figure out how to complete a formula using COUNTIFS, HAS, and AND, if that is even the correct route to go! I need to count the number of times a group of resources occur in 3 separate projects within a single program plan. I have a column for “Group” but we need to roll up a number of groups into one upper…
-
Adding two COUNTIFS
Hi, I am trying to add two COUNTIFS from different sheets and using the formula below. =COUNTIFS({Engineer Live Rota}, $Name@row , {Date Live Rota}, >=DATE(2020, 2, 1), {Date Live Rota}, <=DATE(2021, 1, 31) + COUNTIFS({Archived - Rota Range 1}, $Name@row , {Archived - Rota Range 2}, >=DATE(2020, 2, 1), {Archived Rota Range…
-
countifs not working via choosing whole column or selected cells
Dear team i try to count the delayed task using Countifs. But this formula is not working either manually typing my column header or choose whole column or selected cells. So my asking is how to add the range fast and correctly?
-
Count multiple criteria across 2 columns
I have a single program plan made up of 3 separate projects (that do have dependencies between them). I have been asked to count the number of times resources appear in each plan. While I have been able to create a simple formula if I only need to count one resource group at a time, now I need to count multiple resource…
-
I need to pull certain data from a sheet to another with specific criteria such as (completion 0%)
I am trying to write a formula that allow me to pull certain data from another sheet with completion % 0 and with specific type/name. I need help with the formula
-
Pull content from multiple rows into another sheet.
I have Timesheets and would like to create Invoices. Right now I have 2 sheets, Timesheets and Invoices. One person can have multiple timesheets for the month. Can I move cell contents from 3 Timesheets into one row on the Invoice? I have tried a Join/Collect but it is only capturing one row. Thanks!
-
Weighted Average
how to get the formula to get the weighted average of the scrap