IF(
Discussion List
- 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 …
- Hi, I used this formula in one column on Sheet 1, it looks at Sheet 2 and finds the Site Name and if the Status is Committed, it pulls in the number of Committed Trees. It works just fine for the Comm…
- 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 w…
- 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 f…
- 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…
- 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# / […
- 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) =…
- 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 ea…
- 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 o…
- 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 …