-
Formula that automatically calculates for new entries
I have a helper column that counts sequentially, and because of the syntax I can't make it to be a column formula, but I've been told multiple times that if I drag fill the formula over 2 or more rows, it will automatically calculate when new rows/entries are added in the adjacent column. For some reason this has never…
-
Avg(Collect( using a date criteria?
Hello =IFERROR(AVG(COLLECT({Delta Testing1}, {Assigned To1}, TeamMember@row, {RT1}, "<>Parent", {Delta Testing1}, "<>", {Delta Testing1}, "<30", {Testing Month1}, "=6")), "") The above formula works as intended, but I am trying to add one last condition. I need it to also filter only data that is within the last year. I…
-
Creating a Counter
Does anyone know of a way to create a counter so everytime a cell becomes a specific work it adds one to the counter. As a coder I would use a loop but I am not sure how to approach this from a formula perspective or if its even possible.
-
Adding at risk based on health color
I'm trying to make a formula to set a flag in the at risk column based on whether the health is red and at least 3 days past the due date. Something isn't behaving quite right on the 3 days part and it's flagging some things that are not yet 3 days past due.... Here is what I have, is this not correct? =IF(AND((Health@row…
-
Multiple IF statements in the formula
Hi! I want to create a priority matrix using urgency and important. I've used this formula below. There is no error on the formula but the cell only returns P2. I feel I'm doing something wrong with adding multiple IF statements. Please help =IF(Urgency@row = "NOT URGENT", IF(Importance@row = "IMPORTANT", "P2",…
-
Placeholders in Message field for Update Requests
When creating a message for an update request, I am trying to make an automation for general use. Within the message I tried to include {{Customer Name}} where Customer Name is a column name. I was reading somewhere that this should be able to pull in the details from the Row the update request is being sent for. However,…
-
IF ERROR
Hi there, I need a hand setting up a formula between two sheets. In sheet 1, I have a list of names and a variety of states. In sheet 2 I have a list of names and a variety of states. I would like a formula in sheet 1 that looks at sheet 2 and returns a checked box of the combination of name and state is not found in sheet…
-
Is there a way to auto-number a WBS without having to create multiple hidden columns?
I'm creating a WBS and would like to auto-number the rows by parent/child relationships. All I have found in community are suggestions that require the creation of numerous hidden columns, which isn't ideal or very sophisticated. Is there a more efficient way to get this automation?
-
Nested IF OR Statement
Hello community...I am looking to complete a nested IF OR statement and am missing something. I want to return red if either values are below 0, Yellow if both are between 0 & 8 or $0 & $250,000, green if both are above 8 & $250,000 Cell Name - INVESTIGATE33 Value - 6 Cell Name - INVESTIGATE57 Value $235,000 Here is what I…
-
Include attachment in automated workflow email??
Is there a way to include an attachment in automated workflow email? I tried using the "alert someone" workflow and selected "Links to sheet and specific fields" and then selected "attachment" but it didn't work.
