-
COUNTIFS with multiple contacts in the same cell then reference a second column
Hi, =COUNTIFS([24-7 PM]:[24-7 PM], HAS("Jon Cornwell", @cell), [Project Type]:[Project Type], "LV Switchgear") I am trying to create a summary which shows how many of a certain project type a project manager may be involved in. Hope that makes sense I can get the first part of the formula to work on its own..…
-
SUMIF ?
Can someone help with the correct formula for the following: I need the JO Volume column sum if the PO Forecast Month column is marked 01-January. Below is what I have so far, but it is not working. I appreciate the help - thank you! =SUMIF([JO Volume]1:[JO Volume]40, [PO Forecast Month]1:[PO Forecast Month]40,…
-
Formula help for previous month
I have a helper column for a report that I want to check the box if the DATE cell is in the previous month. Any help is appreciated!!
-
=OR(ISBLANK Formaula
Hello, I am trying to build a =OR(ISBLANK formula into a text box column. Check will display is any cell is blank. I have the following formula but is displaying #INCORRECT ARGUMENT SET. =OR(ISBLANK([Producer Code(s)]@row, ISBLANK([Servicer AM/AE Codes]@row, ISBLANK([SIC Code]@row, ISBLANK(FEIN@row, ISBLANK([LOB’s to be…
-
IF Formula
My goal is to return two potential values depending on what is selected in a multi-select column (Named: [VA...DBQ Worksheet] ). The dropdowns are: Service Connected Diagnosis Blank Service Connected Diagnosis Incomplete (Rated as vs. Contention Name) Bilateral Indicator ICD Code If any of the first three are selected I…
-
List all unique values from a column within one Smartsheet in a separate Smartsheet
Hi All, In my Smartsheet I have a column for Workstream - each row (deliverable) in the Smartsheet has a Workstream - there could be one or numerous Workstreams. In a seperate Smartsheet, I want to be able to pull all Unique values from the Workstream Smartsheet. In Excel I would simply do something like -…
-
New! TIME function for formulas
Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format from a given set of values. Syntax TIME(time_value, [ format ], [ precision ]) time_value — The value to create time with. Must be provided as a…
-
Multiple IF Statement giving an #UNPARSEABLE error.
=IF([QTY 1]@row = "", "0"), IF([QTY 1]@row = "1", "1246"), IF([QTY 1]@row = "2", "2492") This formula is currently returning as #UNPARSEABLE I have a helper column that is my "QTY 1" column, as this increases I would like the "Price per" column to double in price. Prices stay pretty static and change very rarely. I feel…
-
Contains Function cannot find value for contact list data type
Hello, I'm trying to use the COUNTIF and CONTAINS functions to count the values in the percent column based off the values in the Names column with the contact list column type. Here is the formula I have so far: =SUMIF(Names1:Names3, CONTAINS("Anthony", @cell), Percent1:Percent3) And here is the data: When I change the…
-
JOIN COLLECT Cross-Sheet Formula Not Returning Content
Happy 2024, everyone! I'm trying to find the error in a JOIN(COLLECT) cross-sheet formula and am overlooking something. Here's the setup: Sheet 1 - The JOIN(COLLECT) cross-sheet formula is in the Status History field. Sheet 2 - The helper sheet where a column formula is used in the Status History field to combine the…
