Sign in to join the conversation:
Hello! I am looking for a way to auto-populate my Assigned To column from my Stakeholder Registry. Any way of doing this? Or is the solution manually updating your Smartsheet Contacts?
It depends on what column type your Assigned To column is. Contact type columns cannot be automated. If it is a text or dropdown type column it can be automated either to just populate the appropriate name or (with a fair amount of workaround) to act as an automated Contact type column. It depends on your need and how much time you are willing and able to invest in the building of the sheet.
I have tried to set them as Edit - can share, Edit - cannot share, and commenter and nothing works, they cannot add data to the sheet. Does anyone have a solution?
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.
