-
Formula history is now viewable in Cell History in table view
February 09, 2026 Users can now view the history of any formulas entered into a cell using the Cell History feature in table view (an improvement over the current grid view experience). Learn More Environments availability: Commercial US, Commercial EU, Commercial AU Plan availability: Pro, Business, Enterprise, Advanced…
-
Formula Assistance - Unparseable
Hello, I am trying to create a formula to count the amount of times 0, 1, 2, 3, 4, 5 were answered for each of the column categories wihtin the last three days to display on a graph on a dashboard. I was successful in creating the formula in a sheet summary, but cant get that to display correctly on a dashboard graph. So I…
-
Smartsheet Solution - Dynamic Configurations
We are trying to develop a Smartsheet solution to replace an Excel file that is bursting at the seams and is running slowly due to the number of columns and rows. The existing Excel spreadsheets break down configurations, determining the number of units based on total volume and percentage. The ultimate desired end state…
-
Doing a mass update of sheet reference names
I have been waiting for find/replace within formulas, but wondering if there is a different way to solve my problem. I have raw data in quarterly sheets that feed an annual sheet where the data is broken out monthly for the whole year. Every year I create a new annual sheet and have to update the formulas with the…
-
What formula is best to summarize dropdown lists by options?
Hello, I have multiple surveys with drop-downs that I need to summarize and create a dashboard. I need to know the number of times each option was selected. Can someone help me figure out the best way to do this? I am new and still haven't learned formulas. Thanks in advance for the help!
-
Combining data from 3 different columns to create a summary report
Hi all. I am trying to create a summary repot that combines 3 columns that I have on an Intake Sheet and Archive sheet. The data that is in each of these columns are pretty much the same, but we have them separated out based upon on the different clients that we have. Within these 3 columns, it has Job type data (i.e.…
-
Using INDEX/MATCH for a Master Sheet
Hi all, One way we use Smartsheet is to record real-time data that is then stored and referenced. I work at an aquarium so, for example, we will take daily measurements across multiple systems for things like temperature, salinity, pH, and on and on. The same parameters are tracked for all of our systems, but the thing is,…
-
References applicable by workspace
I really appreciate the current cross‑sheet reference functionality in Smartsheet but creating additional references for the same source sheet—especially after one already exists—can feel repetitive. It would be incredibly helpful if, once a cross‑sheet reference is created, that reference became accessible to all other…
-
Correct Formula Syntax for checking for excluding blank cells
I have a RAID log sheet where I want to add a helper column to capture the aging (duration) of each issue row that has not been marked as complete (and I want to convert the formula to a column formula). This sheet is generated for each project via our control center solution so there are several rows at the top of the…
-
Stacked IF statement not evaluating all "value if false" options
I have 6 columns of dates that outline a chronological study process: Phase 1 Forecast date & Actual date, Phase 2 Forecast date & Actual date, and Phase 3 Forecast date & Actual date. I would like to consolidate these 6 dates into 1 column ("IX Study Status") that simply gives the current study status. I wrote a stacked…
-
Check box for start date and end date that fall within Today's date
Hi Community I have a check box column with a column formula to check if the Start Date and End Date are Todays Date. =IF(AND(ISDATE([Start Date]@row ), ISDATE([End Date]@row ), [Start Date]@row <= TODAY(), [End Date]@row >= TODAY()), 1, 0) This works when there is a date range, ie Start Date is 18/2/26 and End Date is…
-
Any suggestions for keeping infrequently-visited sheets/reports/formulas updated with current data?
Hi everyone, I have a scenario that worked well for 3 years, but in the past 6 months or so has become unreliable: As part of a templated toolset, I have a couple of 'worksheets' (where users are visiting and making updates), a 'calc sheet' that's pulling information together from these worksheets via index formulas with…
-
Circular References and Parseable Errors with cells that contain Emojis and Text/Numbers
I'm new to Smartsheets and attempting to transfer tracker data from Google Sheets to build dashboards. I use emojis in trackers and COUNTIF formulas to summarize the data based on emoji categories. The formulas work as long as there is no other data in the cell but I get a "0" if there is any other text in the cell. Please…
-
Blocks for vacations
We use Dynamic View to report and schedule jobs for us (we don't use Resource Management). We don't use the calendar view as it would have too many assignments. I want to be able to put vacation times/blocks in so that my Ops manager will see the block as he schedules work weeks out.
-
Sum Collect or If Statements
I’m trying to build a formula that can achieve the following logic, but I’m struggling to get it working correctly. I have a data sheet with around 100 project rows. Each row contains a Fab Start date and a Fab Finish date (along with many other fields). Some projects run across two consecutive months. In my metrics sheet,…
-
Index/Distinct formula suddenly stopped working last week
I had a formula to list all distinct values from a column in another sheet. I was using this formula and it was working fine until last week. What could be wrong? =IFERROR(INDEX(DISTINCT({Liste de matériel Plage 1}); Séquence@row ); "") When I remove IFERROR, I get #INVALID DATA TYPE
-
Converting Drop-down Date to a Date formatted value
First off, I am using Control Center to build out projects that are dependent on a central worksheet, "Weeks of…" as a drop-down source list. The "Weeks of…" is contained in a Portfolio folder in the Admin workspace. Secondly, I have a worksheet, "Weeks" that contains a number of dates, DATE. In this worksheet I have an…
-
UPDATE - Health and Wellness Solution
Here is what I have built out so far for my Health and Wellness Solution. Please note some information has been redacted, including my Forms Dashboard which is where I go to log most of my entries, it is more for me to see, it's not as pretty as these are. I'm a dork and record many things just for the fun of it. I started…
-
Is it possible to subtract a duration from a date which drives the start date
What I am trying to do is Helper - Duration = Actual start date. So, for example: 14Apr2026 - 22d = Actual start date. Is this possible? Note: I need to keep dependencies turned on.
-
Unable to edit formulas
Any one have issues with suddenly not being able to edit formulas? I am admin and owner of the sheet one other admin has access to sheet and no locks have been placed on the cells.
-
Set a value on one sheet if that sheet's row ID exists on another sheet with a certain status
I have Idea IDs that appear on two different sheets (sheet A, sheet B), and I have a column on sheet B called "Update needed?" Sheet A also has an Idea status column. I need a column formula for sheet B's "update needed" to be set to Yes if sheet A's Idea ID=sheet B's Idea ID for that row AND sheet A's status is "Not…