-
Count cells from another sheet <> to a value or is blank
I am trying to count cells from another sheet that do not equal certain values OR are blank. When I create a filter on that sheet, I find 40 cells that fit the criteria. However, my formula from my Metrics sheet counts 0 cells. COUNTIFS({Subtype}, <>"Electronic Messaging", {Subtype}, <>"Core Sales Aid / Visual Aid",β¦
-
cut and paste referencing
Hi everyone, It seems Smartsheets uses absolute cell reverencing and consequently cells with formulas lose the cell references when cells/columns are are moved/changed Is it possible to use relative referencing to avoid formulas losing their cell reference? thanks for any advice Tim
-
Copy a date to a cell only if there is not already a date there
I'm trying to capture a date from a cell to another cell only if the current cell is blank Here is what I have so far: =IF(ISBLANK([Proposed PROD Release Date]@row), "", IF(ISDATE([Proposed PROD Release Date]@row), [Proposed PROD Release Date]@row)) This formula is in [New date] cell but I only want this to occur if newβ¦
-
Counting Incomplete Past Due Activities by Category
Hi all, I'd like to get a total count of the activities in my project plan which meet the following criteria: 1) "Expected Due Date" is past due (<= Today) 2) "Expected Due Date" is not blank 3) "Done?" is unchecked 4) "Category" is "ABC" I assume I'll need a check box column with a formula to indicate if these criteriaβ¦
-
VLOOKUP to another sheet - cannot pull these fields into a report, getting #ERROR
I am using VLOOKUP in a sheetΒ (call it Sheet2) to pull data from anotther sheet (Sheet1). Then, I'm creating a report that pulls data from Sheet2. This report is pulling some of the data from these VLOOKUP columns. I'm seeing an issue where theΒ report can only successfully pull data in sometimes. Sometimes I open theβ¦
-
VLOOKUP returning "incorrect argument set" error
BRAND NEW TO SMARTSHEETS HERE: I have two sheets which have a unique ID column in common as a key. Sheet 1 will have only a single time this key will be listed. Sheet 2 could have many entries that have the same ID value displayed multiple times. I am trying to pull a field from sheet 1 into sheet 2. I want column 6 fromβ¦
-
IFERROR within a formula
Any help would be great I thought this would be simple, but it isn't working. Original formula: =WORKDAY([Production Begins]@row, +[1st Proof Lead Time]@row, {Holidays Range 3}) provides a date in the column. Formula with IFERROR added: =IFERROR(WORKDAY([Production Begins]@row, +[1st Proof Lead Time]@row, {Holidays Rangeβ¦
-
Identifying Duplicates
Hello again! Trying to use formula to call out any data in a column that are duplicated. I referenced another post to try and solve this, but I cannot get this to work. See screenshot below. I have (2) duplicate numbers in this sheet (first 2 rows and last 2 rows), but this formula its not identifying them. This formulaβ¦
-
sum the count of Children to a parent row
I have 4 PM's and I want to see the # of jobs they are assigned with the parent row showing the total # of Jobs of all PM's. I have no problem with the count formula for each PM, but I can't figure out the formula for the parent row. For example Parent Row: Total: 16 - what is the formula that would give me the Total ofβ¦
-
Index Collect Looking at Auto Number Column
I have an index collect statement in one sheet that uses a column with an auto number value in another table. I get an invalid value error with the formula. However, if I change the column type to text/number from auto number it works.