-
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 a…
-
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.
-
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.
-
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…
-
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