-
Help counting items in a column in another sheet if between defined date ranges
Collecting the count of an item column in another sheet if the date range is between two dates. I am using this formula and it works well, but a bit labor when I have 48 that have different source and date ranges. Plus thinking of 2025, it will be a pain to redo them when the next year rolls around vs just changing the…
-
Sequential numbering based on information in another column
I'm trying to create a formula (preferably one that can be converted into a column formula) that will generate a sequential Change Order Number based on the position and number of times the Contract # is used in my sheet. I'm attaching a screenshot of what I need the finished product to look like. I'm sure I will need an…
-
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?
-
SUMPRODUCT Workarounds?
Hey all, I'm evaluating Smartsheets for my business and trying to determine whether workarounds exist for some necessary calculations. Three big ones are cost calculation, weight calculation and inventory management. I currently use Excel for these. My arrangement is I have all our products on the top row, with all of our…
-
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…