-
Count special characters in a cell
I'm wondering if it's possible to count special characters in a cell, created from a cell formula Count String Occurrence in a Cell — Smartsheet Community What I'm currently doing is adding a period to a JOIN(COLLECT function which I am counting the periods. See below: =JOIN(COLLECT(Post$1:Post$300, [Position…
-
Need help with a master report to create conditions within a calendar.
I am trying to create a master report where it shows vacation days for the team as well as due dates for the projects they are working on. With that being said, I would like for the start/end date to show on the calendar for vacation, but ONLY the end date to show for the projects since they are usually pretty long…
-
Formula for checkbox when date is previous month (and considers previous year in Dec)
How can I alter this formula so that in December of each year, it only considers December of the previous year? As it stands, it's pulling in Dec '22 data. I only want Dec '23. =IF([Payment Date]@row = "", "", IF(MONTH([Payment Date]@row) = IF(MONTH(TODAY()) = 1, 12, MONTH(TODAY()) - 1), 1))
-
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 -…
-
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…