-
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.
-
Schedule Health Balls Change Based on End Date and Status
I'm looking to have the schedule health balls change color based on the "Status" and "End Date" columns. Green = "Complete" OR "In Progress" with more than 2 days to "End Date" Yellow = "In Progress" with 0-2 days to "End Date" OR "On Hold" Red = Not "Complete" after the "End Date" Thank you!
-
Formula - Return month as text from a date cell.
I want to use the formula: =TEXT(*CELL WITH DATE*,"mmmm") But this doesn't seem to be a valid formula on Smartsheet. So if I have a cell with the date "01/01/19" - I want it to show "January" in another cell.
-
How do I populate dates from a date column into my date formula?
I'm running a Countif function that counts production between two dates, currently my formula looks something like this: =COUNTIFS({Reference Column}, <=DATE(2024, 1, 5), {Reference Column}, >=DATE(2024, 1, 1)). For the date part of my formula, is there any way to input dates from two date columns so that I don't manually…
-
Formula does not appear to be working
Okay, first, here is my formula: =IF([Release Name]@row = "", "", IF(COUNT(ANCESTORS()) = 0, 1)) It is in the far right (second image) in the column named Is Parent, which is a checkbox. I only noticed this issue as a result of checking on these release numbers that are a variation of the same number with letters as a…
-
Cell Link/Reference - COUNT Question
Good Afternoon all, hoping for some assistance with this formula I am putting together. For my Number of Dealers Column on Sheet 1, I am trying to get a formula to count the number of Dealer ID's that fall under a certain Market. For Sheet 1 the formula will be looking up cells from Sheet 2. The formula needs to match the…
-
Please add a ROW() Function
This simple function would enable (or simplify) formulas. Autonumbering is the current alternative but requires a column and is clunky. ROW() is helpful to grab cross-sheet data via INDEX when there are multiple sheets with the same row structure but different access permissions.
