-
How can I update this formula to exclude a column?
=COUNTIFS({Territory}, HAS(@cell, $Territory2), {Domain Owner}, HAS(@cell, $[Tech Domain]2), {Status}, HAS(@cell, "Not Started")) - COUNTIFS({Territory}, HAS(@cell, $Territory2), {Domain Owner}, HAS(@cell, $[Tech Domain]2), {Status}, HAS(@cell, "Not Started"), {Post TSA}, 1). I need to add to the formula (I am not good at…
-
Index Match only returning first index option?
Hi, The Goal: Use index match to return a column name based on which column in a given range has the maximum value of that range. The problem: I can only get 1/5 of my return options to work, and only when I add 1 as 'column index' field to the Index formula (usually column index is optional- I've never needed it in any…
-
Help with unparseable COUNTIFS
Here is the current unparseable formula which isn't working; any help is much appreciated: =COUNTIFS([CATEGORY]:[ CATEGORY], "Criterion1", [[TOPIC]:[ TOPIC], "Criterion2"])
-
Form is not populating to Smartsheet - Help!
Hi there, Created a Form and tested successfully last week, data entered into Form after submission populated properly to Smartsheet. This week, 'live', form info when submitted is not (making it to) populating data to Smartsheet. Any idea why this is happening? Thanks!
-
How to search a row for a date among blank values?
I am trying to create a nested IF(ISDATE())... function to pull the date from the columns right of the first column. However, when I try this, after the first IF(ISDATE()) function I am get error message "#UNPARSEABLE." I am unsure of why this is happening. I have tried retyping it multiple times, but am still getting the…
-
Is there a way to trigger a workflow if an end date changes by 5 or more days?
I'm looking to create an automated workflow to copy any row from a project plan that has the end date changed by 5 or more days. Is there a formula I can include in the automated workflow to accomplish this?
-
Can Index Match pull multiple records?
I am trying to pull contract numbers from an Active Contract file over to a 2nd file using the customer name as the unique identifier which is working just fine via INDEX(MATCH), however, if a customer has more than 1 active contract it only pulls the first one over. What's the best way to pull all of the contract numbers…
-
SUM and DIVISION
Can you check my formula for getting the % for the month It should be add 121-365 Days and Greater than 365 Days DIVIDED by Grand Total
-
SUM(IFERROR(INDEX(COLLECT(MATCH))))
I may have just the brackets wrong or overthinking this but I need to return the SUM of column 'eOEM' when the 'Date of report' column is in the next 7 days AND the 'transaction status' column is "New". The formula I have is =SUM(IFERROR(INDEX(eOEM:eOEM, COLLECT(MATCH("New", [Transaction Status]:[Transaction Status],…
-
Creating a COUNTIFS formula to record number of quotes provided by a salesperson in a calendar month
Hello! When using COUNTIF formula in a summary sheet (referencing another sheet) to show number of jobs quoted per salesperson, as follows: =COUNTIF({ASSIGNED TO}, [Primary Column]6) ..... where Primary Column shows the name of the salesperson How would you write a COUNTIFS formula to read the Date Quoted column as well to…