-
Auto Checkbox Formula
Would you help with an auto checkbox formula please? I want a checkbox to automatically check yes, if the sheet is 7 days past the created date and another checkbox in another column is not checked by the 7 day mark.
-
Dashboard
I am trying to create a widget on Dashboard for project progression that includes factors such as "Total development cost to date" "Total development cost this calendar year" "Future spending in next 1,2,3, months". How do I program the cells in sheets to reflect these dates (ie. todays date plus 20 days for next months…
-
Formula to find in Col1, output Col2 of same row to Col3 of different row?
I have content in one row with a Title column and a Description column. They are related, but the Description is only populated one time but relevant to any content that has the same Title. How can I write a formula that says "if (specific)Title, output the content of related Description" to "Output"? The Title occurs…
-
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…