-
How to keep a function in a cell after selecting a value from a drop-down
Hi Everyone, I'm starting on Workflows now and I have a column called STATUS with drop-down values of Open, Sent for Approval and Closed. Additionally I want this formula on the STATUS column - If the Review Step Approval, set to Approved otherwise Closed. So I when the Approver, approves the work (The workflow logic sets…
-
Duration and finish dates
Hello Is it possible to create a Formula or another way to do the following example: Industry Injection mold making I have allotted 5 days for a task. ie starting on Monday- finish Friday once finished they move to the next operation. start on the following Monday I have a check box to machine the parts. in progress…
-
SUMIFS 3 criterias
Hi, I'm trying to create a formula with 3 criteria but it doesn't work. Here it is: =SUMIFS({Hours (1)}, {Période de paie ING}, [Période de paie]@row, {Centre de coûts Projets 1}, [Numéro de projet]@row, {Colonne Employee name}, {Alberto}) When I remove one of the criteria (no matter which one), the formula works well! I…
-
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…