-
Why is datamesh triggering duplicate rows
I have the following column set up as a primary key for a datamesh. The intention is to copy each row over to a reporting sheet 1 time each month. This formula has not changed, and the records within the "BCA #" have not changed - yet I see to inserts into my reporting sheet from a smartsheet automation with differing…
-
Unable to View Workspaces and Sheets While Creating Cross-Sheet References
I am experiencing an issue while creating a cross-sheet reference in Smartsheet. When I open the Reference Another Sheet window: * The list of available workspaces and sheets does not load. * The Recently Viewed Sheets section is also empty and does not display any recently accessed sheets. * As a result, I am unable to…
-
Manipulating a date
Ideally what I'm trying to do is take a date in a cell and add 5 months to it. I've looked here to find answers and found multiple options. Everything is giving me an "#INVALID COLUMN VALUE" Here is what I've tried so far =IFERROR(DATE(YEAR(Start@row), INT(MONTH(Start@row) + 5), DAY(Start@row)), DATE(YEAR(Start@row) + 1,…
-
Data Mesh
When Data Mesh implemented by Smartsheet it was working fine that is years ago but now even though with immediate update its taking 7-8min if person wants to see results immediately its really not working
-
Need Gov‑Safe Method for Detecting Resource Conflicts (Date Overlap + Name Match Failing)
I'm working in Smartsheet Gov, which has several limitations that don’t apply in commercial Smartsheet (ex: no Manage References, no HAS(), no FIND() in COLLECT, and very strict parser rules). I’m trying to build a “Calendar Conflict” flag in my Project Plan sheet that detects when: * A task’s Start/End dates overlap with…
-
How to automatically populate Assigned To across multiple lines
Hi all, I a very new to Smartsheet (4 weeks) and this community so my apologies if my question doesn't match the rules. I have built a PMO template and profile which I will integrate with control centre to automatically generate a new project triggered by HubSpot. The template has a set of activities across multiple…
-
Hey! This is the Report Format I am hoping to have auto populated through 3 forms multiple times a day. I would love some help building this form.
-
Trying to sum columns based on value chosen from linked sheet
Scenario: I have 2 sheets: "AFE" and "Lines". There is a 1-to-many relationship between AFE and Lines (one AFE may have many lines), but I haven't set up parent-child in "Lines" because users will add entries in any order and I can't enforce any kind of sorting or parent-child relationship. In "Lines", there is a linked…
-
List of Locations
I have a master sheet with students and the locations in which they live. Some students live in the same location. I need to make a sheet that shows the unduplicated list of locations where students live. I need this on a sheet so that I can then add more details about each location. The vision is that I'll have a list of…
-
Automation - When a request is approved I want to automatically copy to another sheet
I have an intake form and sheet for my team to review/approve/deny Press Requests. There is a separate sheet that is a calendar of all Marketing Activities, which press items are a part of. I want to create an automation that instantly copies approved Press Requests to the marketing Calendar. I only want to send specific…
-
How to link Task Start and end Dates to another project template file using a formula
I would like to update one task in another project sheet and have it automatically update on another sheet that showcases the more detail project specifics about that installation. I have thought about using the Index and Match formulas, but that would have to hard code the date and the date would be changing.
-
Payload Food
Hello, I cannot find the file to download so that I can do the steps in my own file as I follow along with the video. Where can I find this? Thanks!
-
Row report link back to specific row
Hello, Right now with a row report I can link back to the sheet the data came from, but not to the specific row. This is problematic when viewing modifications. Ideally there would be a dynamic field that can be added to a row report to identify which row the change was made on. Oddly, I noticed that some columns cannot be…
-
Linking two sheets
Hi! I have two sheets that need to be related. Some of the colums on sheet 1 have to be copied into sheet 2. The columns that need to be on both sheets don´t follow the same order. How do I link them, so that, when sheet 1 is populated, the info directly populates sheet 2´s selected columns? Thank you
-
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…
-
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…