-
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…
-
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…
-
Formula Helper
Maybe I've been spoiled by Excel, but I miss the formula helper. It would be great if SS had such a thing, it would make creating formulas, especially the complex ones, much smoother.
-
Merged: Viewing window for Formulas
This discussion has been merged.