-
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.
-
Autopopulating formulas for column
Hi, Is there anyway we can have a parent row column and have the formula "=IF(COUNT(CHILDREN(FindingType@row)) > 0, 1)" auto-populate instead of having to type each formula for every row of that column? I would like the formula to actually show as 1 for the parent row instead of '=IF(COUNT(CHILDREN(FindingType@row)) > 0,…
-
WEEKNUMBER function doesn't seem to be updating promptly?
Hi, I am using the following formula to populate a checkbox called "this week?" if a fitting is scheduled to take place this week: =IF(AND(YEAR(TODAY()) = YEAR([EXPECT FITTING DATE]@row), WEEKNUMBER(TODAY()) = WEEKNUMBER([EXPECT FITTING DATE]@row)), 1, 0) I'm using the checkbox to filter a report so the user can see what…
-
Clean up reference sheet labels
I've searched how to clean up reference sheet labels within a task sheet when creating formulas, and I can't seem to find anything. It gets unruly when I'm creating formulas in multiple columns. Thanks for the help! Linda
