-
Allow linked cells to trigger workflows
Just as the title says. It's really frustrating when you want linked cells to trigger a workflow but you can't.
-
Automated reminder for an approval request
I have a process for requesting approval that requires approval from 5 different people. Once the first person approves, the request is forwarded to the next person. How can I set up automated reminders for each approver if the status remains "submitted" for more than 3 days?
-
Why is a formula not triggering unless someone opens the sheet?
Hi there, I have 150 sheets that individuals use as time sheets. The sheet has rows for all the dates for a quarter. I have a "Current Month?" check box column in the sheet that checks the cell if the row date is in the current month. It uses this formula: =IF(MONTH(Date@row) = MONTH(TODAY()), 1) I have another check box…
-
Visible audit log instead of "view cell history" for numerous lines of data
I know I can view who marked a check box through view cell history but I'm looking for a way to display the person who marked an "approved" or "Done" check box without all the extra clicks; I need a visible export format as an audit trail. I can't rely on the "modified by" field because we have users that go in after an…
-
Provide a way to see the history of automations
It would be nice to see: all the triggering events of an automation all notifications and recipients of automated notifications version history of the automation configuration
-
Workflow Alert Mail
Good afternoon, I would like to ask if there is the possibility to create a workflow that sends email (Action: Alert someone/Request an update/Request an approval) using emails that are in a column inside the sheet but the type of the colum is a Text and not a Contact List. Thanks
-
How to generate an ID number, incrementing by 1 the last ID number created in previous row?
I have a sheet with already multiple rows created. I have a column with ID numbers for each row. I want to set up an automatic way to generate an ID number for all future rows added. For exemple, the last row created has an ID number of 2300. How to automatically generate an ID number of 2301 for a new row added?
-
Column Formula Alternative?
I have people entering information into a sample request sheet using form that allows the user to select multiple types of tests they would like to have run. The form populates "Sheet 1" and I'm using automations to create multiple lines on the destination "Sheet 2" using this solution: In the Source Sheet: Count of Rows:…
-
Teams Integration with Workflows
Hi, We have Smartsheet setup with MS Teams and Smartsheet sends alerts to a smartsheet specific channel. However, when I am building a workflow and add my organization there are no teams displaying in the drop down. We talked to MS and everything looks correct on the admin side. Does this feature actually work? If so, how…
-
Work around for Data Shuttle not recognizing identical data
Hello! This is pretty hard to explain but I am hoping someone can help me with this dilemma: I am using Smartsheet to build a tracking system that monitors where field project workers are showing up on a weekly basis. I get the job addresses as a spreadsheet from another department. Since I am working with hundreds of…