-
Action : change cell value
Hi Community, I feel like this is simple question, but I can make it happen. If I want to using change cell value in automation workflows, can I change the cell value by using formula? Cause I use the formula to change, the result always add ' in front of the formula…(show as the pic below) Besides, can it make the value…
-
Is there a way to generate an alert/block on Smartsheet, in case a schedule causes overallocation?
Hello everyone, On Smartsheet, I have a workspace containing a series of sheets (one for each active project) where various resources are planned. Both on Smartsheet and Resource Management, each resource has 8 hours/day available (i.e., 1 day = 8 hours). If I schedule a resource on two different sheets, assigning it to…
-
Automated project ID using 2 column variables
Hi! I'm trying to create a formula or automate the generation of a project ID but it needs to include 2 separate variables where the information are in 2 separate columns. Column 1: Has 1 of 5 pillars with the pillar number and text. Below Build a community to enable the academic mission Create a thriving, fair and diverse…
-
Dashboard PDF
Is it possible to automate sending a PDF version of the dashboard to a group or manually selecting something to send a PDF of the dashboard to a group?
-
Increased Expiry Limit for Attachments
We use the PDF generator tool to auto-generate thousands of approval letters each year. We then have an automaton set up to send the letters out the funding recipients. the validity period for the letters is 90 days, but the attachment link that Smartsheet sends expires after 30 days, meaning we get many requests from…
-
Merged: Add Descriptions to Automations
This discussion has been merged.
-
Automate Generate Documents
Is there a way to automatically generate documents when a new row is added?
-
Automation Settings Should Be Kept When Saving a Template
Currently, If you update automation settings on a sheet, and then save the sheet as a template, the automation settings do not save. When using the template, all automation settings revery back to 'restricted'. All settings should carry over from the source sheet.
-
Move Row automation stops working when there is a row deleted from the sheet
We have put a condition where one of the column has a dropdown change, then move the entire row to a different sheet. However, we see that the Automation had stopped working and while performing a troubleshooting exercise, we found that when a user deletes any rows from that sheet where the automation lies, the workflow…
-
Campaign Calendar
Hi, I am trying to set up a campaign calendar in smartsheet. But when Calendar tries to pull information from the spreadsheet, this is how it looks(attached). It cuts in between the rows. I created a ticket, but smartsheet closed it without resolving it. Can anyone help?