-
Return a date or month
Hello! Is it possible to write a formula to get the following result - Start Date Column: if it's a confirmed date, a date two weeks earlier in a photography due date column is calculated (this works by using this formula: (=[START DATE]@row - 14)) HOWEVER, if a start date is TBD and I put in the Start Date Column "March…
-
Finding the oldest date on multiple sheets and also based on text in another cell
I have 2021, 2022, 2023, 2024, and 2025 sheets with different departments' requests for action (RFAs). I am looking for a formula to show me the oldest open RFA for each department. Some departments will be in 2021, but some will be in 2024. A sheet summary formula is not what I am looking for. I need a reference sheet…
-
How do I use multiple IF statements with multiple criteria?
I am new and trying to write an IF statement with multiple criteria. The sheet will accept my formula, it will only deliver the result in the cell for the 1st two statements. I read a ton of remarks from others in the community, and I just can't find where I'm making the mistake. Any help at all would be much appreciated.…
-
How do I create multiple IF statements in a function
Here is my current formula for the column "Tech Setup Price" =IF(AND([Tech/Set Up]@row = "yes", [Is the frame curved? ]@row = "Yes"), 650, IF(AND([Tech/Set Up]@row = "yes", [Is the frame curved? ]@row = "No"), 500, 0)) This does not include the below added variable of the Neo Modular System, so I want to add that variable.…
-
What am I doing wrong in this sheet summary?
I am trying to do a sheet summary formula to get the percent of tasked closed assuming Project Name is "RPA Project" Please see formula: =IF([Project Name]:[Project Name] = "RPA Project", (Closed# / [Count of Status]#), "") The Closed # and Count of Status are also sheet summaries Below are their formulas:…
-
"Week of" formula with Friday as start of week
Need the formula below to recognize that the beginning of the week is a Friday. If the "Date of Shift" lands on a Friday, then the "Week of" should be the same date. =IF(WEEKDAY([Date of Shift]@row) = 7, [Date of Shift]@row - 1, [Date of Shift]@row - (WEEKDAY([Date of Shift]@row) + 1)) Below is a screenshot of the formula…
-
How to set up columns to track status by week and not erase when moving to next week?
I have a project with tasks organized by rows. There is a column for status of each task. I've created columns for each week progressing into the future where I want to log the status at the end of each week in each column. My issue is that once we are in a new week, it leaves the previous column (week) blank. How do I…
-
Inventory Check In/Check Out with Forms
Hey Everyone, I'm looking for how to automate a check in/check out process utilizing forms. What I want: Tech fills out form with the item's serial number and checks a box for if they're checking in or checking out This creates a new row in a helper sheet (CHECK OUT) A master inventory sheet (EQUIPMENT) update's the…
-
How to set up columns to track status by week and not erase when moving to next week
I have a project with many tasks organized by rows. There is a column for status of each task. I've created columns for each week progressing into the future where I want to log the status at the end of each week. My issue is that once we are in a new week, it leaves the previous column(week) blank. How do I keep the data…
-
Need a space saving IF OR formula
I have a working function to assign a school county to a new entry when a certain institution ID is put into the column. My issue, however, is the complete equation to accomplish this is too long and doesn't fit the last few school districts. I'm checking to see if there is a more elegant way to accomplish this so I can…
