IF(AND
Discussion List
- I have a working formula where I need to add one more criteria to a COLLECT function but can't seem to get it working. Here is the current working formula: =MEDIAN(COLLECT({Platform Test - Submit Stat…
- 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 …
- Hello! The sheet on the back end has multiple checkmarks to select what role the event is for. I am needing to create a formula that will give a Academy name based off of which checkmarks are checked.…
- 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…
- Hello Brilliant People! I'm stuck on this IF formula incorporating time and multiple conditions: *Quick detail, I work in construction and this is regarding a form my guys use twice a day to do a safe…
- I have been trying to rank my rows that are listed as "Tier 1" in the {Level} column in order of importance based on the following criteria: 1) Highest Rank: Rows with the oldest {R/O Create Date} AND…
- 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…
- Hello Community, I am looking for some help with a helper column checkbox formula needed to support reporting of data to a dashboard and downstream formulas. I have four shifts (A,B,C,D) entering data…
- 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 …