-
Why is my Level Code formula erroring on just level 2?
I'm trying to produce a WBS. I used the helper columns and formulas from the Smartsheet template set. The Level Code formula works on all but the 2nd level (purple) which shows #NO MATCH. Expectation: First purple line should read 1 and second purple line should read 2. WBS works fine if I hardcode those values. Anyone…
-
Can I do a stacked bar chart of status types by week?
I've been asked to create a bar chart for a hypercare log like the one shown in the attached screenshot. The ask is to have a stacked bar for each week showing how many cases were active in a given week and how many were of each status (New / In Progress / Resolved / Escalated). The ultimate goal is to see the trend of how…
-
INDEX, MATCH, and OR Function
Hello, I am trying to use INDEX MATCH and the OR function. I'm referencing 3 other sheets try to say if we find x in any of these 3 sheets I want y from those sheets. x and y will only be present in 1 of the 3 other sheets. However every I do this I either get an error code or unparsable. These are a few of the formulas…
-
Logic Help
I am trying to come up with a formula that will change my "Has been billed" column to Yes or No based on the dropdown choices in one column and the created date, I am having trouble coming up with some logic that can work around the year with sporatic billing periods. Here is my current formula: I either have remnants from…
-
SUMIFS pulling data from another sheet and applying criteria of a date range
Hello, I have scanned through previous posts and could not find one that matches my situation. I created a Metric Sheet which I want to pull footages from another sheet that fall within a date range. I followed the formula syntax and ensured my headers are correct and the format for date range is also correct but I keep…
-
Copy/Paste retaining formulas with multiple sheet & summary field references
This just may not be possible, but no worse off if I ask. We have a 'table' of data constructed of cells with formulas using sheet references, and summary field references. We are trying to consolidate our metrics into one central sheet for easy annual/quarterly updates as they are used across multiple dashboards. The…
-
Allow for Smartsheet to pull and return column names into a formula
Unlike some other spreadsheet programs, Smartsheet formulas cannot reference the actual header row (row 0) as data. I have a sheet which tracks many dates pertaining to our projects. Each column is named for the relevant milestone. I built a column formula that can iterate over those columns and pull the most recent date…
-
How to show parent and child rows with filter on?
I believe I need a helper column but I have no clue how to start it. We have a filter set up and when we turn the filter on, we are not able to open the child rows. I have included screenshots. Thank you!
-
SUMIFS formula bringing back total of all items, not items in specified date range.
Hello, I'm using a SUMIFS formula to try and get the sum of materials, done during a specific process, during the specified date range of May 04 2026 - May 08 2026. But it continues to total all entries in that column, instead of giving the total based on the provided data. I've also tried using both OR and AND functions…
-
Control Center Find/Replace formula not working
I am trying to do a global update within our Blueprint on just one sheet in the summary section. All sheets have the same column name and the same row. We are trying to change the last "Description$8" to be "Description$12." When I look at the test sheet, it still has the "Description$8."