-
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…
-
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…
-
Tired of messy image attachments in Smartsheet?
Tired of messy image attachments in Smartsheet? I built a small tool that lets you upload images directly into **cells (not as row attachments)** — making sheets much more structured and easier to review. 🔹 Before: Multiple attachments per row → hard to track 🔹 After: Images mapped to specific columns (clean & organized)…
-
Combine Contact Lists
Hello. I am trying to combine contact list A with the Created By column into one Contact Helper column to use in order to restrict the user view in Dynamic View. Here is my problem. Contact List A is filled in from a form submission. The user is supposed to enter or select their email address along with the emails of any…
-
Cross-Sheet Formula Help
I have two sheets: the first sheet is called 'Source Sheet', and the second is called 'Helper Sheet'. I want to use the Helper Sheet to track survey responses that are fed into the Source Sheet. The formula should reference a column in the first sheet named 'Company Email'. If that column is not blank on the Source Sheet,…
-
Hammock Task Creation
One of my clients uses Hammock Tasks to represent Project Management and Organizational Change Management in their projects. A Hammock Task is one whose Start and Finish dates are driven by different Milestones. The Start Date would be the date of one Milestone and the Finish Date would be the date of a subsequent…
-
Additional Criteria changes result
Hi folks, I'm struggling with a formula that should be simple. When the formula is this, it works great for one of two Types. The second type pulls the wrong Billing Annual Fee. =IFERROR(INDEX(COLLECT({Billing Annual Fee}, {Segment}, Segment@row, {Billing Ownership}, [Billing Ownership]@row), 1), 0) When I modify the…
-
Auto Collapse child folders when the parent folder is expanded
Today, on the Browse side bar, when you click the icon, it displays a toolbar with all the Sheets and Workspaces the user has access to. All these folders are collapsed by default. When a user chooses to link a cell from another sheet, the data source menu auto expands all of the folders whenever a workspace is expanded…
-
Referencing another Smartsheet when #NO MATCH is found
Hello, I've been struggling to find the appropriate formula and AI hasn't helped either. Here is some context as to what I'm trying to accomplish. In my "calculation worksheet" I have a table with Data Links setup. These all work as intended with no issues. The problem occurs because after an items has been marked…
-
Using Datamesh then want to cell link to source so updates will appear in target
I am using a master project list, filtering out certain jobs with a report, then using DataMesh to move the jobs onto a Intake sheet. I then want to cell link critical data from the source into the Intake sheet so any updates from the Master are reflected in the target sheet. I create the Inbound cell link, but when a new…