-
Work around for Placeholders to work for a grouped update request
Hello Team, I understand that email message Placeholders no longer work for update requests that have more than 6 rows grouped together, but I wanted to know if anyone might know a certain type of work around where placeholders might work. Curious to know anyone's work!
-
Count Formula for more than one condition
Hi. I need to complete this formula: =COUNTIF([Team Member]:[Team Member], "Joe") and Status <> "Complete" or "Not in Scope". What is the recommendation to determine how many outstanding tasks Joe has? Thank you.
-
Subtracting 1 month from TODAY, previous year error
=DATE(YEAR(day13), MONTH(day13) - 1, DAY(day13)) I am using the above formula to subtract one month from today's date for a rolling 12 month report. However, the formula errors above 15/01/22 (I expected it to revert to 15/12/21) is there a way I can build the formula so it does not error and continues into the previous…
-
Finding the last highest value, and subtracting from @row value
Hi, I have a sheet where CNC operators enter the hours the machine has worked each day, and i want to avoid them having to reset the time clock eacht time. I have been struggling with a formula that helps me achieve the following objective: Find the highest number of hours entered for the same machine on the current row…
-
Formula to sum data in another sheet that meets a certain criteria
Please help! I've got two sheets: Sheet 1= called 'Requisition' (the main sheet) & Sheet 2 = called 'Dashboard Data' I want to put a formula in the 'Dashboard Data' sheet that adds (sums up) data that's in the 'Requisition' sheet. The information I need is a combination of two columns. Column 1 = called 'Number to…
-
give a drop down value a percentage
I have a form with a number of questions (columns) that have drop down's with answers to pick. poor, fair, good, exhalent, I need to be able to work a percentage and average base base on these answers I need each to have a individual numeric value poor 25% fair 50% good 75% Exhalent 100% Eg if all 12 questions were…
-
Does INDEX(MATCH) work on a column with a formula?
I am attempting to use the INDEX(MATCH) formula with the range being a column that is calculated with a formula. I keep getting a #NOMATCH message - can MATCH only work on a column that has actual values (i.e., not values calculated from a formula)? I am trying to use this formula: =INDEX({Billing Code}, MATCH([Identifier…
-
Find the average of hours, minutes, seconds
Hi there, I am having difficulties finding the average of hours, minutes and seconds. I have 12 months of data for timings, and the format is in hours, minutes, seconds how it is in excel - 00:00:00. I have to find the average for each month, for an entire years worth of data, and it gives me an error when I look for the…
-
Using a formula to subtract out a Contact
Hello, Is it possible to use a formula that when given a contact cell with multiple assigned contacts, and a secondary cell with one assigned contact, will SUBTRACT that contact from the first cell? So in practice it would look like this: Cell 1: Contact1, Contact2, Contact3 Cell2: Contact2 Cell3: Use a formula that…
-
How to use MAX COLLECT for dates
Hello, I need to pull the most recent date for maintenance based on the most recent date entered in another column. I have several pieces of equipment I am working with, so I need to specify with the Equipment ID. I have tried =max(collect([Last PM Date]:[Last PM Date], [Equipment ID]:[Equipment ID], US-149)) but I receive…