-
New proof info columns and automation enhancements!
Hi Community! Have you ever wanted to automate the proofing process or have more insight into who’s approving or requiring changes? Us too! With this release, you’ll be able to track each person who has voted ‘Approved’ or ‘Changes Needed’ on a proof, as well as each person who hasn't yet voted. This enables you to stay on…
-
The smallest date with a specific status in the child cell
Hello community, I hope this message finds you well. I need a formula to classify as TRUE if my row has a "Not Started" status and presents the smallest start date within the cells, which in the example figure, are filled in white. However, I couldn't come up with an efficient result. Any tips or help to build this formula…
-
Non-repeating email notification when value in sheet is reached.
Hi all, We have an automation set up to send an email for when a certain value in a cell reaches 50%, 75% and 100% of a predetermined value. For example, the automation will fire when the cell value is 10 of the predetermined value of 20 (50%). Our issue is that the notification fires off again every time the cell value…
-
Scheduling automatic reminders for Proof reviewers
Here is a way to create reminders for Proof reviewers. This solution will: Send a reminder 5 days after the initial invite, if no one has responded to a Proof review request. Send a reminder 5 days after the last reminder, if no one has responded to a Proof review. Reset when a new Proof version is created. Some useful…
-
Default notifications when someone has been assigned to a row.
Is there a way to have smartsheet default to letting someone know that they have been assigned to a row? I know that you can set up an automation workflow to achieve this, but with the amount of projects we have going on across many different users, the chances of everyone going in to set up the automation and do it…
-
Run an automation frequently to entire sheet.
Hi All Is there any possibility to run an automation number of times within a day?
-
smartsheet API key is not able to fetch data from the smartsheet having MFA.
I am not able to fetch data from the smartsheet using API key which is having MFA. I am getting an error - "This action is restricted by an MFA Policy. Please reach out to the workspace admin for any questions.". How I can resolve this issue?
-
Automation sending emails without conditions being met
Starting a few days ago, I am receiving automation emails from Smartsheet for conditions that have not been met. These workflows were implemented several years ago, and have never had a problem like this. I went and triple checked to confirm the conditions are not met. I deactivated the automation and reactivated thinking…
-
How to make Value be based on a cell for Automations?
Hello, I have a automation where i need it to trigger when a cell matches another cell value. So I have a column with an requestor email that is inputted by a form that Person A would fill out. I also have a modified by column to show who was the last person/automation to modify it. I also have a text field for additional…
-
Auto Record date of change
Hello, I'm encountering an issue with the "Record a Date" function on one of my sheets and would appreciate assistance. This function works flawlessly across many of my sheets, but for some reason, it fails to record a date for two specific changes in this particular sheet. I've experimented with various configurations of…