-
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…
-
Increase limit for workflows triggering other workflows (aka daisy-chained automations)
I have a "Re-Release" process that is very long and complex. At one point in the process, a row goes through a series of automations that trigger each other. These automations copy the row to an archive sheet, move the same row to a "Re-Release" sheet, copy the ID# to an "Previous ID #" column, clear the data in over 60…
-
An HTTP client error occurred while trying to connect to the Smartsheet API
Has anyone run into this issue with the Salesforce Smartsheet connector? I was informed that a workflow stopped running (I'm not the owner of it) due to this error at first: The owner of the workflow does not have access to this sheet. Either it was deleted or you were removed from sharing. I confirmed that the owner of…
-
Error message indicating a recipient is not receiving an alert
Hi, We run an automation to alert a Smartsheet group that about a change in a Smartsheet table. Whenever the automation is run we receive an email indicating that particular person (shown by their email address) is not receiving the alert. The person in question has left the company, his email address has been removed from…
-
Can Smartsheet automatically email a generated PDF from Document Generation to the email address submitted in a Form?
Hello everyone, I'm building an automated Above Ceiling Work Permit process for our hospital and have almost everything working. I'm hoping someone can tell me if the final step is possible using native Smartsheet features. My current workflow A contractor scans a QR code and completes a Smartsheet Form. The form creates a…
-
Best practice for cross-team project dependencies and consolidating reporting?
Hi everyone, I am looking for advice on the best way to architect a cross-team project tracking system. My current setup: I have multiple teams, each maintaining their own individual project sheet. Each sheet contains a list of projects specific to that team. The Goal: Cross-team Dependencies: I want to add a dropdown…
-
Automation
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
-
Dynamic View — Support "Current User's Group" filter & capture actual modifier for existing rows
Hi Smartsheet team,We have two feature requests related to Dynamic View:## 1. Filter by Current User's GroupCurrently, Dynamic View does not support filtering rows based on the current viewer's group membership. We need different teams (e.g., Security, DCEO, DCO) to see only their relevant rows automatically, without…