-
Connecting two Smartsheets (one a set list of assets, the other freeform)
I am trying to connect two Smartsheets. This is my current setup: The first Smartsheet (Smartsheet A) contains a list of shared assets, designated by an alphanumerical ID. When an issue is identified in one of these assets, it's set up so that when someone clicks the flag button, it notifies others. The second Smartsheet…
-
Marking Successors Status as "Ready" when the Predecessors Status is changed to "Complete"
I am working with a large sheet and developing an automation to update task statuses: when one task is marked as "Complete," the subsequent task is automatically set to "Ready." While my formulas are functioning correctly on a smaller scale, the size of my new sheet is leading to performance issues. Currently, my sheet is…
-
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…
-
Gantt Chart Baseline - Added Functionality
On first glance it seemed like gantt chart baselines did exactly what I wanted to do - compare an "actual" start/end date to "forecasted" start/end date. When I actually went to go use it, come to find out all baseline does is take a snapshot of the dates/duration when the activity is first added and NO edits/modifications…
-
Building a formula based on a check box
Good afternoon. I am trying to solve a problem with our projects (we do not have resource management). for projects that are escalated we have a check box that our managers then see with a report due to the check box. Once the project is back on track, the check box is unchecked and the project goes back to the PM. I want…
-
Status Change within a Cell Formula where it moves it to the next stage if true
Below is what I need in a formula string to generate these items from a dropdown list within the cell. Cancel WT = Yes, Status = Cancelled If Demand Planning/AMT Input Complete (AMT) = True, Status = Finance to Add Cost If Finance Input Complete (Finance) = True, Status = IC to Set Up TO IF TO# (Inventory Control) is not…
-
Automation won’t stamp “Last Changed” date when Status is formula + linked cells
Hello! I’m trying to timestamp when the value changes in a Status column I've created, but the Status column is formula-driven and its inputs are linked cells / cross-sheet references from multiple source sheets. In my Master sheet, the Status column is a formula. The fields that drive that formula are not manually edited…
-
Sharing lessons learned - hiding rows & columns - replicating formulas across sheets - disaster plan
Warning! Long-ish post coming your way with multiple topics I wanted to share. Throughout, if I’m missing a functionality whereby I’m needlessly fretting, please, please let me know. Intro Hiding rows and columns administratively across 20 unique Sheets Porting in and out of MS-Word for large find / replace formulaic needs…
-
AVERAGEIFS or AVERAGE(COLLECT()) Help
Hi! I am struggling to get this formula to work correctly. The Smartsheet-AI generated formula is returning #UNPARSABLE and I am not too familiar with Average Collect. The goal: Average the column "Total Days Open" if the following criteria are met: column "Business Type" is NOT "retail" and column "Division" is "Northern"…
-
% Complete Column Appears Broken
The screenshot shows an assignment I am working on for an online class. I have a question about the lines highlighted in yellow. The "% Complete" column is supposed to show a calculation of the children's done percentage, I think. Am I understanding that correctly? If so, the Campus & Grounds line (NPI-052) showing 51%…