-
Round Whole Dollars Up to Five Dollars
I have a column that takes a rate and decreases it by a discount percent: =[List Rate]@row * (1 - ([Client Discount]@row + [Selected Discount]@row)) For Example $ 300 less 15% discount = $ 255 $ 250 less 15% discount = $ 212.50 $ 90 less 15% discount = $ 76.50 I want to apply calculation that will result in rounding up to…
-
"IF" function question - Urgent if possible
I have a sheet where i am tracking multiple different tasks for completion. i am attempting to create an (Overall status) once a few key items are marked completed, and or box is checked. Can someone explain how this can be done? Example: EDI setup-completed, testing successful check box checked, contracted check box…
-
Multiple IF/AND Statements
Hoping someone can assist me with a formula. I've spent quite a bit of time trying to figure it out on my own and can't seem to get it. I have multiple criteria to determine the value of a field. The field values would be Ops, G1, NG2, G2, and Full depending on various criteria. Here is the logical expression: If [Tshirt]=…
-
How do i write the following formula
I am trying to write a If-nested formulas that works out the following. What i am trying to say with this formula is the following: IF the status is Complete and the planned end date is today or within five working days = Green IF the status is In Progress and the planned end date is today or with in three working days =…
-
Counts of values in a multi-select column
I'm trying to count the number of values in column that allows for multi-select. In this case, column is Contract Type - and the request can involve multiple contract types...I'd like to be able to count/total individual the types of contract types.
-
updating cells without loosing easy overview of historic data - how to?
We have a list of customers, where the invoice changes from month to month according to use of specific items. Example: Customer A will in January pay for 2 item Y, 0 zero item X, and in February pay for 3 item Y, 0 item X and in March pay for 1 item X, 3 item Y. Q1: Is it possible to have the customer update this…
-
Vlookup Limitation?
Hi I would like to understand about this limitation in vlookup: * Each sheet can include no more than 100 distinct cross-sheet references. * There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total.…
-
IF OR AND Statement
I am trying to return color symbols for in a sheet. End goal Date Null, Completed Null, or Past DATE(2020, 3, 31) = "Red" Date is Not "Yes" and Not Past DATE(2020, 3, 31) = "Yellow" Else = "Green" Here is the code =IF([Date Completed]1 > 0,IF(AND(NOT(Completed1 = "Yes"),[Date Completed]1 > DATE(2020, 3,…
-
Trouble with RGYB and blank dates
Hello! I am working with a Health column that refers to our Status column and start/end dates. I have a formula that is working once the dates are entered, but when I use a fresh templated sheet and there are no dates, it looks as if all the tasks are delayed. (see pic) I would like: Green if complete Yellow in in progress…
-
COUNTIFS Cross Sheet: 1 Column is blank and 1 Column is not blank
Hello, I'm doing a master summary metrics sheet (in lieu of a summary sheet on the source sheet because I need to build graph charts in a dashboard). I need to count blank cells in a specific column, but only if another column has text. I'm using this formula: Where Range 1 will indicate if a new submission has been…