-
alert with specific row
How can I set up to send an alert for specific row when it matched a condition . I tested it and it triggers correctly but always send the first row. for example, it should send out the 10/10/2022 row only, but it sends out 10/2/2022 row any idea? Thank you
-
Broken Workflow Report
Is there a way to run a report (or an easy search) which lists which projects (over 300 of them) have a broken workflow, rather than checking each one individually to see if the automations are broken?
-
If Statement to Change Drop Down List Value
Hi all! This is more of a clarification to another question than anything else. I have a column of drop down lists ranging from 0%-100%. With that being said, the default value is blank, if would like to make a column long formula that does the following; if the current cell is blank, set value to 0%, else do nothing. I…
-
Can Document Builder work on .docx files instead of .pdfs?
My team would like to have documents autogenerated in Smartsheet with .docx filess specifically mapped to the Smartsheet. I've only been able to do this with PDF's, is it possible for .docx word files?
-
Auto Reminders
Hello, We are setting up a workflow in smartsheet that once submitted via form, will flow from one approver to the next. There is no standard as for when the entries will be submitted. I need to set up a reminder for each approver so after 48 hours, if they have not approved, they receive a reminder that an action is…
-
Template Set: Marketing Request Management - Standards - Scope of Work cells
I am following the initial setup steps for the Marketing Request Management template set. In Step 2.C. customize the sheets for your project types and team, when I change the cells in the Standards - Scope of Work sheet, it breaks the communication to the Intake Sheet and Form, and gives me an error message "Incorrect…
-
Microsoft Power Automate can not reach sheets
Hi there; i would like to use microsoft automate to change a sheet to excel online by a flow.But on powerutomate step when i want to choose sheet , power automate only see workspaces , and folders , when i choose a workspace and then under it a folder , after this step automate says there is no any sheet .Why it can be ,…
-
Autopopulating Dates on a Sign-up Sheet
Hello, Does anyone know if there is an option to auto populate dates for a sign-up sheeting on SmartSheet? For example, I have sessions that individuals are allowed to select from October to December. However, I do not want those dates to show up after they have passed. So, if today is 10/4, then I do not want my sessions…
-
Workflows > Actions: Request an update > Recipients: Contacts in 'contact in row'
I’m having an issue with a workflow being executed, but emails are not going out. I first thought it was because our security was blocking emails, but that is not the case….did a sample to my personal email address (which is less stringent), but still no execution. When I performed a test “request an update” on 13-15…
-
How can we automate a quarterly email with Smartsheet content in the body?
We have a Smartsheet with some content that I would like to format in an email in such a way that recipients are able to act upon information without needing to look at the Smartsheet. We have a list of Key Users in a column who I would like to send an email each quarter. If possible, I would like to include the name of…