-
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…
-
How Do I Sum Up Values from One Sheet to Another With Different Criteria?
Starting with the basic of, how do I populate from one sheet to another while adding a running total? The next layer to this is, how can I get different sub sections to specifically populate into another sheet. In my photo you'll see "Parent Node F" with a total footage in bold and a delta (Production Master). In the other…
-
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…
-
Harvey Ball changes based on completion and dates
Hi, once again I feel I'm so close with this one, as I can get Blue and Green to work as expected, but Red and Yellow don't appear to want to play ball (see what I did there?). =IF([% Complete]30 < 1, "Green", IF(AND([End Date]30 < TODAY() +10, [% Complete]30 < 1), "Yellow", IF(AND([End Date]30 > TODAY() + 10, [%…
-
Issue with using formula to count rows in sheet that do not contain certain text
=COUNTIFS({All Deals Input (Master) Range 1}, $[Primary Column]@row, {All Deals Input (Master) Range 2}, [IDR In Process]$2, NOT(CONTAINS(OR("Kill but Follow", "On Hold"))) + COUNTIFS({All Deals Input (Master) Range 3}, $[Primary Column]@row, {All Deals Input (Master) Range 2}, [IDR In Process]$2, NOT(CONTAINS(OR("Kill but…
-
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…