- Dynamic Fields Issue - Subject Line Issue
所以…中级知识Smartsheet. Weird issue. I've tried messing with the syntax and arrangement... Subject 1: "{{MeetingID}} - Notes" Automation Email Subject 1: "Changes to Meeting Log - Project: Project Meeting Minutes" Subject 2: "{{MeetingID}} - Action Assigned" Automation Email Subject 2: "Team Huddle -…
- Control for Character Entry on Form
Hi there - Is there a way to control the characters used for a form? I would like to limit to just roman letters. If this isn't possible, a suggestion for a work around on the grid? ie. We have event rsvp that are entered in Chinese characters then have to translate later. Would prefer to restrict on the form itself.…
- How to ignore blank cells when stringing cell values together
Hi everyone! Hoping someone can help me out. I have created a Smartsheet form that someone can fill out to create a custom URL. On the backend of the Smartsheet, I have a formula set up to string all the values together and add delimiters into a url string. It works great, with one exception. All of the form fields are…
- Smartsheet alert 3 days before the first Thursday of the month
Is there a way w/o having to create a date column and just list the first Thursday of each month manually to send an alert 3 days before. I know I can send one for each 1st Thursday but I need the alert to go off a few days before. Thank you
- automation to update a date field to new value
Hi, I am trying to set up an automation where it detects when a date found in column DATE is passed and then would automatically update it based on the value found in the column frequency for example : if the DATE = 01/07/2021 and the frequency = Weekly then when we pass the date 01/07/2021 it should automatically change…
- How to include changed fields in an alert
I want to alert the project manager of any changes to records managed by that project manager and include only the values of the fields that changed. The fields that were modified could be 1 or more of dozens. So I do not want to include ALL fields -- only those which have been modified. Is that possible?
- Automatically Select Contact With Column Formula
Hi, I am fairly new to smartsheet so I apologize if this is a basic question. I am trying to automatically populate a contact column with a single contact indefinitely. For context, it's just so that in a separate report that pulls from many sheets, a filter that only allows a row assigned to a contact to be shown can be…
- Automating weekly report
Hello, I currently am trying to automate a process but having few issues:I currently send out an email manually to send their top 3 accomplishments, top 3 issues for last week etc. I am trying to automate the sending out email. I want to keep the historic data but do not want multiple columns with each week. Is there a way…
- How to have a date dynamically changed based on a value in another column?
I'd like to be able to have the dates in a column update based on the Sprint number. So, I've created a new sheet with one column with the Sprint # and a column for the associated dates. I have a column in my main project spreadsheet titled Sprint #. I'm having trouble figuring out how to tie it all together. I've been…
- Avoid automation sending same email to contact listed on multiple rows
I have set up a sheet that lists every web page on my company's site and has a column listing the Content Partner who is in charge of that page. I have a workflow that alerts the Content Partner annually to review their pages. Often, one Content Partner will be listed for multiple web pages in any given month (because they…
