-
Formula for Unique Values
I need a formula that will check a check box column when a project name is not unique. The check box column is "Duplicate Portfolio Name" and the name column is "Portfolio Name".
-
AND/OR Function for COUNTIF Referencing another sheet
Hello, Smartsheets Gurus! I am building a formula to reference another sheet {ISIR Pulls 2023-2024, Column EX Major (Range)} with two different EX Majors within the range I'm trying to total up. The two things I am looking to identify are EX Major "BSC" and "BSD". If I just do: =COUNTIF({ISIR Pulls 2023-2024 Range 1},…
-
How do i set up a conditional format, when i want more than one person in the assigned to column
I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?
-
Cannot set formula to column formula due to absolute reference
=COUNTIF([Serial Number]$1:[Serial Number]@row, [Serial Number]@row) I need to convert the formula above into a form that allows me to set it as a column formula. =COUNTIF([Serial Number]:[Serial Number]@row, [Serial Number]@row) does not work. Is there a work around for COUNTIF? I was thinking I could write a similar…
-
SUMIFS Formula with multiple criteria excluding blanks
I would like to sum a column, only if another column with dates falls between certain dates, and if another column with dates is not blank. I have the first part of the formula sorted but can't get the part to include if another column is not blank. The formula I have is: =SUMIFS({Area (m2)}, {Del Date}, >=[Start…
-
How do I add days to an existing date?
I have read through this community about the same question, however, the solutions haven't seemed to work for me. I'm working on a Debt Snowball sheet to calculate and estimate when my bills will be paid off. I can use EITHER the Months or Days column from the DATE column. For example - need the formula to add 8 months (or…
-
INDEX COLLECT Multiple Values that match a date range
Hello community! I want to return the name of every BROADCAST that falls within the date range where I have a contractor coming on site at my office. In my contractor sheet I have a start and finish date column. Contractor Start: 02/20/24 Contractor Finish: 02/21/24 In my Broadcast sheet, I have over 100 broadcasts…
-
COUNTIF with a certain word in a week
Hi All, A client wants to be able to see how many calls were logged in thier current working week . However the working week begins on a Friday 00:00am and ends Thursday 11:59pm. I'm after a formula to count all entries with the word "Aberdeen" in the Column called "Club" in the mentioned working week . This counter would…
-
Issue with 0 prefix in the reference number
Hey SmartHeads! I have a weird issue in SUMIF formula: ASINs Value Total SUM: =SUMIF([F Tracking ID Number]:[F Tracking ID Number], [F Tracking ID Number]@row, [X ASIN Value (CI)]:[X ASIN Value (CI)]) it works perfectly fine for all numbers under Tracking ID Number, except the one which starts with '0'. see: when I create…
-
On Time and Past Due Formulas
Hello, I am trying to create a formula in Smartsheet that replaces a formula we are using in Excel that turns a cell red or green if the date entered is before or after a referencing cell date. If that makes sense. So – If the Review SOW date cell in a column is in the past and the Review SOW Complete cell is blank, that…
