-
Index, Match formula returning some, not all values
Formula was flowing correctly, but some change seems to have partially broken the pull but I can't figure out what/how. "Project" column dropdown is linked to a Master sheet. Budget Owner column contains the below formula which should look for the cell value in the Project/Cost Center/IO column within the P+CC+IO column of…
-
Count projects completed in a date range
Hello, I am looking to create a summary formula that calculates the projects completed within a given month. From the screenshot, I need a formula that evaluated the 'Status = Posted Live' AND the Actual Completion Date within March 2026. I've been playing with the CountIf formula, but I can't get it to work! Any ideas?
-
Pre-Populate a Form with Query String
Hi, I tried looking at previous posts here to make this work, but I am definitely not doing it right. lol. I am trying to pre-populate 4 fields in a form. Here is the test sheet (public) https://app.smartsheet.com/b/publish?EQBCT=d8c8d8b25bf0477e963e7c07a8ca81bb Below are the form fields I am trying to populate. Any help…
-
Setting up a metric sheet to calculate the YTD sum, but not show data in future months
I’m trying to set up a metrics sheet that will feed into a dashboard to show a rolling total over time, but I don’t want future months to display any data. For example, a user will enter values in the right-hand column, and I have a formula that calculates a rolling total in the green column. The green column is what I…
-
Count IF(s) Formula Help
I need help with a formula in Smartsheet. I'm trying to count occurrences of specific values in my Issue Type column, but I have Allow Multiple Values Per Cell enabled, which is causing issues with the COUNTIF/COUNTIFS formula. For example, my expected results would be: Incorrect Product (6) Missing Parts (2) Defective…
-
Calculating Totals
Hi all, Im trying to use a formula to calculate how man hours of different leave type an employee uses to add to a report and or dashboard. Any suggestions on how to make that happen?
-
"WBS Helper Columns->" column
Does anybody know what the "WBS Helper Columns->" column does in the Project with Work Breakdown Schedule (WBS) template? Is it just a helper column where a function could reside, or does it have an "Off the Shelf" purpose?
-
"Helpful" Popups
There should be a way to hide tips and tricks from Smartsheet. If you have been working with formulas for years, you should be able to type in a formula without a pop up that blocks the other cells telling you how to use the =SUM() for example. It is always in the way of the cells I need to select. Should automatically…
-
IF Formula working on some and not on other items in column
Hi All, I have a formula running in a column to validate an action based on whether it was done prior to 01/01/2011 or not. =IF([Install Date]@row >= 1 / 1 / 11, "Yes", "No") The formula works as required on rows where there is a year only, but throws #INVALID OPERATION where a date has been entered through smartsheets…
-
Construction Phase Count Formula
I'm trying to count how many projects are in the construction phase each month using this formula: =COUNTIFS({Master Project List Range 1}, "2 - Construction", {Master Project List Range 2}, <=Month@row, {Master Project List Range 3}, >=Month@row) It works, but I want to make sure it's also counting projects that are…