-
Conditional Formatting Based on another Cell in the Row (Lab Specs)
Hello! I am looking for a way to make the lab result column values red if they are over the value found in the spec column. There are multiple fabrics each with different spec. They are all being tested in the same manner with the results in a singular column. A VLOOKUP pulls in the spec based on fabric chosen in fabric…
-
Is my SUMIFS formatted improperly?
I'm looking to sum $ column when Status column is "Contracted" and when Job Type column is either "Balcony" OR "Roof Anchor" This is what I have: =SUMIFS([$]:[$], Status:Status, "Bidding", [Job Type]:[Job Type], OR(@cell = "Roof Anchor", @cell = "Balcony")) The result is: #INVALID OPERATION I feel I'm probably missing…
-
Countifs in date range and value range.
I am stuck on this formula, it doesn't become unparseable but it doesn't result in an accurate count. My goal with this is to is to keep an annual tally of a specific age range of patient the formula is as follows: =COUNTIFS({Trauma Chart Audit Age}, <15) + COUNTIFS({Trauma Chart Audit Age}, NOT(ISNUMBER(@cell)), {Trauma…
-
Help with sorting numbers and letters that are combined in one cell?
I would like to sort by a column that has both numbers and letters in a cell. Such as 1, 1a, 1b, 1c. Right now if I sort it by it by the ascending option, it's able to do 1a, 1b, and 1c correctly, however it separates it from the numbers that don't have any letters. For example: This is what it does: 1 2 3 1a 1b 2a 2c 3b…
-
Copy row for all columns before "Yes" Column
I am working on a project, and there will be MANY times that there will be multiple requests. This column is a dropdown with 2 options, "Yes" or "No". If the response is "Yes" I would like the data from that row, all columns PRIOR to that column copied to the next row. If the dropdown selection is "No" nothing is done.…
-
Using format and links in update requests and notifications
Hi dear Community, hope you all enjoy your weekend ? Do you know if it possible to give format to the text in the update requests or notifications f.e. bold, italic, underlined as well as putting URL-links to certain words or make quotations. This would be very important for me 😀
-
Conditional FormattingI
I have a column of dates with conditional formatting that turns the cell Red if the date does not fall on a Monday. This works fine. If the date is longer than 7 days in the past then I don't want the cell Red. I have a helper column that returns a '1' if the date in the cell is more than 7 days old. Now I want to add…
-
Cross Sheet Formula(s) w/ Yes, No, and Hold Decisions (IF & AND)
Hello All, I am trying to utilize a formula from a sheet (Parts Requests) to drive productivity and scheduling on another (Scheduling Board). I have created a formula [Report] to determine if the corresponding materials order has been received, on order, shipped, etc. which corresponds to a Yes, Hold, or No decision icon.…
-
Conditional Formatting Duplicates
Hello, Is there a way to conditionally format duplicates if a value is in a column and if a box is checked? I need this to look through the whole sheet where there are many input values by the customer via a form. Thank you. Brian
-
Auto Delete rows
HI, I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
