-
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…
-
3 Day Reminder - Automations
Hello, I'm looking for assistance to try to get this automation to work. I need an Alert to trigger on weekdays only and if the date in the 'Date Approval Requested to Reg Manager' field is 3 days ago. I only want it to remind them once. Is this possible? I used the below screenshot, but it's going to run on weekends.
-
How to set up an automation with FROM/to changes
Hello Lovely Smartsheet Community! Hoping you can help :) I am working on a deployment project where there are two different eligible vendors, and any of the 7500 clients may switch vendors at any time. Therefore, there are 4 options in my "Vendor" dropdown column: Vendor A Vendor B Ineligible Vendor No Vendor I am trying…
-
Comments on rows that are copied to a new sheet
I want to set up an automation to copy rows from sheet 1 to sheet 2 when a condition is met. Is it possible to have comments that are added on sheet 2 also populate on sheet 1? Basically I want to see any comments added after the row moves on both sheets. Thanks in advance for any advice to solve for this!
-
Pause all Automations. Helps when making sheet changes
We collaborate with a lot of people. Not uncommon to see 30+ automations. Working on large projects, we make changes to log sheets for time to time when the need arises. These changes will often trigger many automations. It would be very helpful to pause all automations, make sheet changes, then reactivate the automations.
-
Auto Sequence by Date?
Hello! I am creating a sheet that will house projects that need to be prioritized by date. Although I can sort them myself and number them, is there a way to auto number a column based on the date column? In other words, if I have 10 projects with 10 dates, can Smartsheet apply a value in my "Order" column based on the…
-
Automated updates to multiple contacts
Good morning! I have a sheet that I am working on for voting on tool enhancement request. I currently have the sheet set up to request voting on 6 categories for a purposed update for our tool. The issue im running into is the update request is being sent to multiple contacts (for test purposes we are using 6 contacts),…
