-
Is Automation Workflow can be triggered by Formula resulted change?
Hi there, I am trying to make a task automation with multiple steps. The idea is I have a master sheet where the task is being copied to from reference sheet (where all tasks in there). The Logic is, when the first task in the master sheet is completed, the second task row will be copied to the master sheet. I have a…
-
Unique calendar year- Countback week number to delivery
Hi All, I am struggling with a formula that I think needs a simple fix, and I am hopeful the community can help. Our product launches mid-week and runs off of a unique 35-week calendar, and we are using the following formulas to track the difference between: THe difference between current workweek to the week of launch:…
-
sum hours of an assigned to, in a multi contact column
=SUMIF([Assigned To]:[Assigned To], =[Assigned To]@row, [Hours Testing]:[Hours Testing]) Works great, if the "assigned to" is only a single person. When there is more than one contact in the cell, it is unable to find. I'd like to not have a name spelled out in the formula eg "Jane" I'd rather it look to =[Assigned…
-
INDEX MATCH MATCH to OTHER WORKSHEET
Hi, I'm attempting to perform an INDEX(MATCH(),MATCH()) operation to match the column headers with a row value from another sheet as one would in Excel or Google Sheets. How do I reference the columns as a range and a value? The formula should be as follows: (in cell B2)…
-
Using COUNTIF and OR functions to match a value within a range of cells
I have a Status column with around 10 values (A-J). I would like to count the rows where status value = A, B, or C. I've been able to do this via an OR function in which I explicitly list the values sought after (e.g. =COUNTIF({Status}, OR(@cell = "A", @cell = "B", @cell = "C")). But this can get quite lengthy if I'm…
-
ISO - Simple At Risk Formula
Hi Friends, Looking for AT RISK Formula - I'd like a formula that says IF Start Date is less than today (in the past) and Status ISBLANK then AT RISK flag is flagged. Below is a completely wrong formula - I just don't know how to get the ISBLANK in there. Can anyone help? Formula challenged but love learning!…
-
Formula to return fraction that represents the number of cells that meet certain criteria
I'd like to return a fraction such as 3/4 to show the number of cells that meet certain criteria. If it returned 3/4 that would mean 3 out of 4 cells met the criteria. Currently, I'm using a percentage rating, but in my opinion, if you don't have at least 10 cells to evaluate, the percentage rating value isn't true in the…
-
formula - Time
I have a sheet with an auto Created date & time column AND a modified date & time column. Is there a way to create a formula column that will show Modified Date Time (minus) Create Date Time?
-
Can I make my status column read both the line above it and the column next to it using a formula?
I've been doing some research on IF, AND, OR equations to try and automate my sheet. Is there a formula that I can plug into the cell highlighted in the image above that reads not only the Status of the line item above it, but the Complete column at the row level as well? I would like for an artist to come in, check off…
-
How to check if a column has a value on a certain row with matching cell?
Hi, I have two sheets, Allocations & Installations. Once an Allocation is approved, the row gets copied to Installation. When the Installation is completed it is marked as such on the same sheet. I would like to automatically have it marked on Allocation as well. They share a [Shop ID] cell. So i need to check from…