-
NETWORKDAYS - glitch
Good afternoon, I'm confused about the NETWORKDAYS formula, as it's not working accurately or I'm using it wrong? I have coverage start date and end date , where I need to returns the number of working days (excluding the holidays) in the last column as shown below. =NETWORKDAYS([Coverage Start Date]@row, [Coverage End…
-
Joining multiple COUNTIFS statements
Hi there. I'm trying to create a single formula that will count items in a column on sheet A if they fall between two dates and also count items on sheet B if they fall between two dates. The item name is the same in both sheets and the date ranges are the same in both sheets. The formula I have (which does not work) looks…
-
Formula to sum data in another sheet that meets a certain criteria
Please help! I've got two sheets: Sheet 1= called 'Requisition' (the main sheet) & Sheet 2 = called 'Dashboard Data' I want to put a formula in the 'Dashboard Data' sheet that adds (sums up) data that's in the 'Requisition' sheet. The information I need is a combination of two columns. Column 1 = called 'Number to…
-
Auto-hyper-link a sheet generated using template
Hi Smartsheet, I got a sheet with each project schedule sheet "hyper-linked", like below project A. If you click project A, a schedule sheet pops-up. I use data shuttle to generate all the data from other internal data. Then, using these data, we use a template to generate schedule. The sheet has index/match formula and…
-
Why am I getting an INVALID DATA TYPE error?
Here is my formula, which references another sheet. All referenced columns are the same type (drop-down) =COUNTIFS({Lead Category}, OR(@cell = "Lite Upgrade", "@cell =New Lite Site"), {Sales Type}, "New Deployment", {Sales Tier}, "Experiencia") Thanks for your help!
-
Splitting a list of contacts
I have a formula that pulls contact names using a certain condition. The problem is that in some cases it returns more than 20 contat names that is the limit for contacts in a cell. I am looking for a way to split the result in 2 or 3 coliumns so any column will not have more than 20 contact names. Any ideas on how to…
-
Using a formula to subtract out a Contact
Hello, Is it possible to use a formula that when given a contact cell with multiple assigned contacts, and a secondary cell with one assigned contact, will SUBTRACT that contact from the first cell? So in practice it would look like this: Cell 1: Contact1, Contact2, Contact3 Cell2: Contact2 Cell3: Use a formula that…
-
SOLVED Invalid Value with COUNTIFS Formula
SOLVED: there were a few invalid values in there causing the counts to not work properly. Lesson learned Hi, I have a COUNTIFS formula that works just fine with my Contact Column data but is not working with a text column; it gives the Invalid Value error. This is the COUNTIFS formula =COUNTIFS([Account Director]:[Account…
-
Pull a value from a cell if date of the row matches today's date
Hello, I am trying to do something that is likely very simple for someone, but I keep hitting an #UNPARTSEABLE error! In Sheet Summary, I am trying to pull a value from a cell if the date of the row matches today's date; else key "Not Available". Here is the formula I am using: =IF([Date]:[Date]@row = TODAY(), [Overall…
-
Why is my NETDAYS function returning a result of more than 36,000
I'm trying to find the difference between today and a prior date, in this image it's the Helper Date column. I've confirmed this is an actual date format with the ISDATE function and it's working as expected in some other formulas. In this formula the result for the row displayed should be 18 days but I'm getting a result…
