-
Tabulating Sheet Summary Data
Is it possible to automatically capture the results of a sheet summary on recurring basis and save them to another sheet? Almost like a daily cron job. I have metrics that feed a dashboard from a open issues list, but want to track trends over time based on those metrics. Currently I only have a snapshot of the live status…
-
Count if Specific Text within a Date Range
I'm trying to create a formula to count a specific text within a column only when it's during a specific date range. I can't figure out where my error is. =COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], >= [2020-08-01], [Date]:[Date], <=[2020-08-31])
-
Trouble with VLOOKUP - pulling from first row, not column
I'm using the VLOOKUP for the first time to pull webinar times in from another sheet for webinar registrations automatically so we don't have to add those manually before a workflow sends meetings links out to registrants. I'd also like to use it for webinar dates if I can get it to work. My issue is that even though I've…
-
Dynamic numbering
Hi, I wanted to know if its possible to have the entry number as the Function + RAID item(R,A,I,D) + number. What I am looking for is for the R,A,I,D items to be named as per the functions- i.e. if its the 'first' R in Funciton1 , the result should be - Function 1. R.1 and if its the 'third' A in function 4, the result…
-
SUM all payments made in the last year
Hi, I'm trying to add up all the payments in a column that were made in the last 365 days from the current date. The date the payment was made is in a second column, formatted as a date column. I have written this formula: =SUMIF([Payment 1 Paid Date]:[Payment 1 Paid Date], TODAY(@cell) >= TODAY(-365), [Payment 1]:[Payment…
-
count the value of the drop down selections
in a sheet I 3 separate fields that have values associated with the drop down selection: Example: Column Headings: Sales Prep Sales Presentation 0 - not prepared 0 - Rep did not show 1 - Basic info 1 - Good presentation 2 - Well prepared 2. Excellent now I want to count the selection in a total Demo Score field Example:…
-
Intake form updated daily how-to...
We have a medical intake form that we have to fill out daily I am trying to figure out how to keep the employee name in only one row and just update the screening details daily not have 300 lines for one employee. We will keep the archived details on another form so I have it set to copy to another form.
-
Establishing Automatic Due Dates
I have a project that has a launch date of July 2, which is represented in a column. I would like to have a due date be automatically calculated 63 days prior to this date, in another column. I have created a formula that appears to work, in principle, but rather than setting the date 66 days prior to the July 2 (April…
-
Changing sheet reference when copying formulas
Hi there, I am designing a process for employee performance reviews. The pre-built template set doesn't exactly do the things that I need done, so am having to build my own. I have created a master sheet with a form to intake the performance data across various categories for different employees. We have 50 employees, and…
-
Why is my VLOOKUP returning erroneous data?
I am using a cross-sheet VLOOKUP formula on several rows in a master sheet. It is working correctly in one column, but for the other column the formula is returning erroneous data for only a few rows. For instance, in a couple of cases it is finding a search value that does not exist in the referenced sheet, then returning…
