-
Automation Action: Auto-collapse parent rows based on status change
Hello everyone, I'd like to suggest a new automation action: "Collapse Row" (reduce/fold a parent row). Use Case: When managing projects with parent/child row hierarchies, once a parent task is marked as "Complete" (or any defined status), all its child rows become irrelevant for day-to-day tracking. Currently, there is no…
-
Cross Sheets/Integrating data
I would like for info entered into Sheet 25 to be automatically updated into Sheet 37. There are no numbers/calculations,- just data & dates, the structure/names of the columns of both sheets are different, child rows are involved. Does anyone know if this is something that Smartsheet is capable of? TIA
-
Dynamic View - unable to create a DV even being an owner of the sheet and having the DV button enabled
Hi I have an enterprise plan and I'm the owner of the sheet I'm working on inside SS. However, when I try clicking the Dynamic View option inside the sheet, it takes me to another tab where I can create new DV's but when I hit "Create" after selecting the right sheet, it doesn't work. It loads briefly but nothing happens.…
-
IF, CONTAINS, NETDAYS, AND, CONTAINS
Hi all, Trying to use a formula to work out net days between events in a column (Visit End Date) when a second column (Visit Description) contains "V" but also only if the last visit also contains a V. =IF(CONTAINS("MV", [Monitor Visit Description]@row), NETDAYS([Monitor Visit End Date]1, [Monitor Visit End Date]2)) worked…
-
HELP! Bridge: Child Workflow "Not Seeing" Row ID from Parent Workflow
Bridge: When Passing an array of data from Parent to Child Workflow, please help me figure out what the data reference should be for the Row ID entry in the Get Row routine at the beginning of the Child Workflow. Thanks in advance, Bill
-
Recent Issues with Workflow Automations
Hi - We noticed that our workflow automations (specifically update requests), stopped working. When we look it says pending but nothing is being sent to the contact nor is it appearing in their notifications. When I run a test it works fine :-(. Notifications on the same sheet are fine. Is anyone else seeing issues.
-
Multi-person Approval Workflow
Hello! Here is the problem we are trying to solve for in the simplest way possible. If a singe request results in a solution that required approval from multiple people (simultaneously, not sequentially), how do I send the approval request to all approvers and track responses from each?
-
DataMesh - Pre Upload the target column name
Hi, why not uploading the same or similar column names pre-populated in the target sheet column in DataMesh?
-
Can't test or trigger automation workflows in Smartsheet Gov?
I discovered after our migration to smartsheet Gov that the test and trigger function for workflows is not present. This seems like a really silly feature to leave out - it makes building complex tools within smartsheet really difficult. I think this is almost a requirement to make workflowa functional or usable,…
-
Is there a way to restrict access in Dynamic View after a user have submitted info through it?
I'm creating a Dynamic View that a user will have the opportunity to view and check mark a box on a quarterly basis, this is to perform a QA check on whether other users should have access to certain files. The idea is that once the user (owner of said files) completes the check marks (if the users displayed should have…