-
IF then INDEX, Match help
I'm having trouble apply my index formula to pull from multiple sheets depending on one criteria (client). I have three client data sheets, WHI, BCN and WHB and I want to pull the same Check% from each sheet depending on the the client. I was original thinking I need an IF WHI client, then INDEX formula. I basically need…
-
Display Value as %
My company uses a formula for the Target % Complete which basically looks at the start and end dates of a task and gives the percentage of work that should have been completed to date. The formula is as follows; =IF(Start1 <= TODAY(), IF(Finish1 <= TODAY(), 1, NETWORKDAYS(Start1, TODAY()) / INT(Duration1)), 0) My issue is…
-
How to convert to @row functionality
I cannot seem to reference the next row down if I convert row numbers to @row from this: =IF(COUNT(ANCESTORS([Task Name]3)) < COUNT(ANCESTORS([Task Name]4)), COUNT(ANCESTORS([Task Name]3))) to this: =IF(COUNT(ANCESTORS([Task Name]@row)) < COUNT(ANCESTORS([Task Name]4)), COUNT(ANCESTORS([Task Name]@row))) what do I do for…
-
Is there an easy way to reference the bottom row of column if there are gaps in the data?
We are after a way to return the most recent/bottom entry of a column, however the column will often have gaps of blanks. I have got sort of close with: =INDEX(Change:Change, COUNTIFS(Change:Change, <>"")) However any gaps you have make it look at the cell(s) above the bottom. Is there a way to get a IF NOT BLANK type…
-
Trigger not sending email
I have two request for update triggers set up the same, only difference is the cell that needs to be updated. Both send emails to my work account. One trigger works but the other one doesn't. If i change my email address for the one that doesn't work to a @gmail.com it works! I notice that if i look in my notifcations in…
-
Numbering rows
Hi, I wanted to know if its possible to have the entry number as the Function + RAID item(R,A,I,D) + number. For example, if its risk 1, in function 1, I want the entry number as "Function 1. R.1" and if its Issue 3 in function 3, the entry number should be displayed as "Funciton 3. I.3" and so on. Please help. Thanks!…
-
IFAND Formula Help
I'm trying to create an IFAND formula that auto calculates the Available remaining balance left to Draw for a certain bank and show it in the summary section at the top. Ex: If we have $1,959,000 available with Farmers Merchant for West Village. I'd like the highlighted cell to auto calculate that total...but only if it's…
-
Is there a way in sheet summary to have a drop down and then another cell to count based on drop dow
Hi there, I have a sheet that i'd like to be able to count entries based off of a drop down selection in the sheet column, and based off of date. I live in Virginia and there has been a mandate that employees must attest to no covid symptoms prior to coming into work. I've created the form and they use through the app.…
-
Our drop down list is dynamic - how can I pull the choices from a list somewhere?
I would like the drop down list to be specific to a group of people (set up in group management). Rather than manually putting in the people that you can choose from, as this group continuously changes, how can I make this dynamic?
-
How do I pull a specified group of people through to a grid?
Group management means we can set up people into groups, but how can I then pull through these people into a grid? I want to analyse workload for a specific group of people. Alternatively, how do I pull through ALL contacts into a grid and make sure when a new contact is added it is automatically pulled into a grid?