-
Check if one contacts column matches another
I want to set up a notification for when a row is modified by someone NOT in a contact list column of "assignees". The idea is that if someone not in the assignees cell modifies the column, then I would notify the assignees. I was trying to set up a helper column that would calculate if a "Last Modified By" system column…
-
Generate list of recently updated sheets
I would like to have a quick readout of the five or ten most recently updated sheets from WorkspaceA or WorkspaceA --> Folder5 I can build a report that grabs all of the sheet rows by updated in the last 30 or 60 or 3000 days, but how can you get a list like: * FinanceSheetXYZ updated Yesterday by John Smith *…
-
IF THEN help
I'm trying to make this work but I keep getting errors. Help!I IF([Document Needed]1, =BO, THEN [Date Initiated]1+30), IF ([Document Needed]1,=LOC, THEN [Date Initiated]1+10) Thank you, Kelly
-
Needing Help with Multiple Logical Expressions Formula
I am working on a formula that will look at a few different cells and make a calculation. I need the formula to look at ETA to Ready = [terminal ETA] + [# of days] The [# of days] is determined by which [Terminal] So I need the formula to look at the value in the [Terminal] column, then add the associated [# of days] to…
-
Counting dates as entries
I am compiling a metrics page, and need to count a date field, teh automated "created" which stores date and time the row was created. I want to count a total of "01/XX/19", XX meaning i dont care about the days, i just want all of January 2019 entries. I am refrencing another sheet (hence the metric sheet), so i need to…
-
IF statement with flag symbol
Per the attached screen shot. How would the formula be written so that the row2 flag turns red IF any of the flags(row3-row11) are toggled to red? Thanks
-
Working Days Counter Based on State, Lock # when completed
I am trying to create a counter that counts the number of days in work of a task, the counter only counts the days in work when the Scrum state of the task changes to sprint . I want the counter to stop counting when the state changes to done and lock that number of days in work (days in work from sprint to done) and still…
-
Automating RYG balls based on several columns
I am trying to automate the RYG ball status column, based on several factors. Red - if not marked 100% complete in the [% Complete] column after the [End Date] or; - if less than 7 days before [Start Date] and [RS] and [WOA] are not both =1 Yellow - If greater than 7 days before [Start Date], [RS] and [WOA] are not both =1…
-
SUMIF Contact? Help please!
I'm trying to get the total of a column where the row contains a specific sales person. Can someone help me out? Here is what I tried: =SUMIF([Sales Person]:[Sales Person], "Kevin", [Appx. Value]:Appx. Value]) Screenshot attached...thanks in advance!
-
Calculating Number of Items in a Month based on System Generated date field
Hello all - Needing help with a formula to calculate how many requests are submitted via a webform for each month. 2 questions related to this: 1. Can a formula pull just the month from a System Generated cell: Created by (Date)? 2. Where are errors in this formula: =COUNTIF({Date Submitted}, MONTH(@cell) = 1) 'Date…