-
Grouping Automation - is there a way to checkmark a group of users based on one singular check?
I currently have a sheet in the following format: Primary Owner Secondary Owner Group Title Username Access Status Primary & Secondary Owner - contains names of owner Group Title - group name of which users belong to Username - user names Access - checkbox column (default value is 'unchecked') Status - dropdown list (Open,…
-
Workflow Automation Run History/Log
Is there a way we can see a log of when workflow automations have run, and if there is a recipient for it, then to see which recipient(s) have received it & when?
-
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…
-
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)…
-
How to delete rows automatically
Community; I manage a process that injects a fairly high volume of rows into a sheet at least weekly. These rows are meant to be viewed by a sales team, annotated, acted on, and then archived. After about a month they lose all value (key data points are moved into our ERP or POS backend, depending on outcomes). But the…
-
Pulling column from one Smartsheet to another, automatically updates
Currently, there is a form linked to a Smartsheet that automatically updates every time the form is submitted. I need to graph data from specific columns, which I want to be in another sheet for visual clarity. From what I understand, I need to pull that data into the sheet I am charting in before I can plot it. What…
-
Autos to move row to new sheet - STUCK!
Hello, smarter friends: I'm trying to learn how to utilize automations to move certain rows to new sheets in order to explore if my larger/longer ranging goal is possible. Where I'm Currently Stuck: I can't even figure out how to create functional auto to send a row to a basic sheet. That is my immediate need. But if…
-
Does Smartsheet have an equivalent to Excel's RAND() function?
Hi, I'm trying to determine whether Smartsheet has a feature similar to a heat map, where cell colors automatically adjust based on changing values across a column. Since the values are constantly changing, using fixed conditional formatting ranges isn't practical. Is there a way to color cells relative to the column…
-
Automation -Approval routing auto declined once approver open the email notification for approval
that is my automation workflow Scenario is for example - user submitted the request for approval there are tier of approvals ; capping amount 0-99,999.00 after RA lead approved the sewhich approval is director of treasury then for the amount 100k and above approval goes to COO but in this once automation sent to the…
-
Automation -Approval routing auto declined once approver open the email notification for approval
that is my automation workflow Scenario is for example - user submitted the request for approval there are tier of approvals ; capping amount 0-99,999.00 after RA lead approved the sewhich approval is director of treasury then for the amount 100k and above approval goes to COO but in this once automation sent to the…