-
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 -…
-
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…
-
Countif for last week during new year turnover
Hello, I have a formula running to calculate how many ride alongs our team completed last week. During the first week of the new year, the formula no longer works correctly and I am having trouble trying to fix it so that it pulls last week (last week of 2023). I have this formula running on a different sheet than where…
-
Counting Columns based on if they contain certain words/names
Hey I have a worksheet that has several columns, what I am trying to do is count 1 column IF it holds "specific text/words" then to add onto this I need it to only count if a name shows up in 1 of 3 other columns. I've tried 15 different formulas now and none of them seem to be working. I thought it would be as simple as a…
-
Why is DATEONLY() returning the wrong date?
Hello All, Does anyone understand the behavior of the highlighted cell below? I believe it should be displaying "08/18/20".
