-
How to highlight the values in the column which is greater than or less than the other column values
Suppose, the order quantity we have taken from the customer is 500, and the quantity we have placed an order with our supplier is 600 how to highlight this excess quantity?
-
Formula column disabled (greyed out)
HI, i'm new to spreadsheet, currently i'm on trial version (30days Trial) planning to buy after using it like one week, yesterday i've noticed i cannot convert text/number column into formula column it's greyed out. i've tried with different sheets different cell types it's still greyed out, please help out. Thanks Vinoth
-
COUNTIFS with DATE
Another day, another question to the Community...! I'm trying to get a count of all jobs starting in each month. My formula is giving me an #INVALID OPERATION error though. =COUNTIFS({Start Date} >= (DATE(2019, 1, 1)), {Start Date}, <=(DATE(2019, 1, 31))) What am I doing wrong?
-
Creating a Skill Grid for tracking
So, I am trying to create something similar to what I have in Excel in Smartsheet where it looks to match two things and if both are present it returns true, if not then false. The problem is it is referencing another sheet for both things. For instance, If Paul's name exists, and he has a date in Column 2, then true. Is…
-
Issue with If Statement
Not sure if it is possible, I have tried some basic if statements but not getting anywhere. Looking for some help please, trying to get an if statement to work in the Validation Status column, where if the due date is over 7 days the status column is populated with 'overdue', or if the due date is within 30 days then the…
-
Return a date from a row, on a different sheet, that corresponds with their name.
I have a sheet that I am trying to inform team members when their license expires and I am wanting a formula that looks at one sheet, if the name is there it return the corresponding value. I can get the formula to return yes or no but I need the exact date. =IFERROR(IF(AND(MATCH($Name@row, {Team Member}, 0) > 0,…
-
Sheet Summary Formula Error due to Formula in Sheet
I'm using Sheet Summaries to total up information in a large sheet. This sheet also uses formulas to pull information from other sheets. I receive a #NO MATCH error when attempting to use a COUNTIF formula in the Sheet Summary on fields that are being pulled from other sheets via formulas. Is there any way around this…
-
Trying to use index collect, vlookup and index to reference two columns on two sheets
I am trying to write a formula based on two sheets. One sheet, Team Members, that has the following columns: Column 1 - Region Column 2 - Industry Column 3 - Contact The other sheet has many columns, but it has matching columns of the same Column 3 - Region Column 4 - Industry Column 10 - Contact I've tried a bunch of…
-
Help identifying duplicates using two columns but excluding entries.
I would like to locate duplicates in my sheet using the name column and email column. Just starting with the name column gets me nowhere. I keep getting #UNPARSEABLE. I am using =IF(COUNTIF(Client Name:Client Name, Client Name@row) > 1, 1) in a separate column. Eventually I would like to include the email column which has…
-
COUNTIFS formula not functioning how I expect
Hello, I am expecting this formula to count the number of cells in the "FND Prepare" column that have a certain name in them, where the cell on the same row in "Prepare Status" is not green. =COUNTIFS([FND Prepare]:[FND Prepare], HAS(@cell, "NAME"), [Prepared Status]:[Prepared Status], (@cell <> "Green")) Does someone have…
