-
COUNTIFS criteria including dates after X
I'm trying to create a formula that counts the number of entries submitted to a separate sheet per person completed since a specific date (3/24/2020). My formula that works for counting all entries by individual is =COUNTIF({Other Sheet Range1}, [Member Name]1) but when I try adding the AND {Other Sheet Range2}…
-
Count Formula
Hello! I am tracking assignments and a person can have more than one assignment. I need to be able to count the number of persons assigned on the sheet but don't want to count dupes. The fields are "First Name" and "Last Name". I'm trying to use the =COUNT(DISTINCT(RANGE) formula but I'm not having any success. Also, there…
-
VLOOKUP with Duplicate Data
I have a master sheet that may have duplicated column data, like: Client Name | Status (dropdown) | Delivery Date | Feature (checkbox) Client A | Rescheduled | 2/5/2020 | 0 Client B | Postponed | 2/12/2020 | 1 Client A | Confirmed | 3/17/2020 | 1 Client C | Requested | | 0 I have a sheet I'm using as a template to create…
-
Subtask inheriting data from Parent
I've a field for ClientName. I would very much like for subtasks to automatically inherit the Parent Card ClientName value. How might I do this? My users prefer using the Card view. They feel that if they have to use the spreadsheet view, they may as well use Excel. So while I may need to build the functionality in the…
-
IF / CONTAINS using a range
Have an issue I thought I had resolved, but ... I have a sheet that has two relevant data ranges: Range 1 = a single column that specifies a Content Type for each row item. There are 7 possible Content Types: Data Sheet, Ordering Guide, BDM, TDM, Demo, Learning Map, Proposal Range 2 = 15 columns that contain a Product…
-
Summary Report - COUNTIF of multi-selection columns
I love the way a Summary Report can kinda be a poor man's pivot table within Smartsheet, and it works really well, up until you try to do conditional counts of columns with multiple selections. See below. What's happening here is I want to allow a COUNTIFS when a person is chosen, and count the number of instances data…
-
Nested if/then/and/or???
Hello out there, attaching a screenshot for reference. I'm trying to get the far right column ("Completely Processed") to check under a series of different circumstances: 'Check Cut to Vendor' box MUST be checked for all cases If none of the 'outside $$' boxes are checked and 'Check Cut to Vendor' is cut, then the…
-
Should I use IF or IF(AND....or Something Else?
Good afternoon everyone. I was hoping someone could help me with a formula I'm having an issue with I tried a few different equations. I found by removing one of the parts of the equation, I received a Yes response, however, when I tried adding in the other part, I received an error of either "Incorrect Argument Set" or…
-
When saving as new, I want to break links including sumifs but I'm having an issue
I have a sheet that's linked into a pivot sheet via a series of sumif cross sheet formulae. This sheet is looking into the pivot sheet at a point in time e.g. month of April YTD information, and the Pivot will update monthly as new data is uploaded to the source report (I will also need the new data but the historical data…
-
IF Checked, Assign Auto Number
Hi there! I'm no excel or Smartsheet formula wiz but I'm hoping someone here can help me figure out a way to do the following: I'd like an auto-populated number to appear in a row when the "Estimate" box is checked. There will be some rows where estimate is not checked and therefore I don't want to dedicate a row to a…