-
Copy Date to Another Field Upon Change
Hi there, I am looking for assistance with a use case that I can't seem to solve, so hoping someone can provide some suggestions. I have a date field called Scheduled Date. A vendor fills in the date into this column when they plan to deliver a task. It starts out blank. I'd like to have it so when they change a date in…
-
Smartsheet automation I separate emails to the same user
Hello, I have a worksheet with in which I use to send emails to an automated ticket creation email for my company. The email is only able to create tickets for one request at a time but I noticed that smartsheet is grouping all of the requests within one email to send. Every single row within my sheet needs to be sent to…
-
Populate Column From Another Sheet's Dropdown Menu
Hi all! I was wondering, is it possible to populate an entire column based on the dropdown menu from another sheet? I have one sheet where all tasks are listed, and are assigned to people via a dropdown menu. I am trying to create another sheet as a cross sheet reference that summarizes hours of every individual. What I…
-
Automation copying values from other cells
Is there a way to create an Automation that when some criteria is satisfied (like status is In progress) and I update one field with the data from another field in the same row? let me explain, I want to automate the % Completion bar progress with the actual % based on the time consuming at today's date. So every day, or…
-
Automation
Hi All! I wrote a Python script that will run an update to make changes when a form submission is added. Works great, however I have to manually run the script. I know you can use a scheduler to run, but I need the automation to trigger when form is submitted. I do not have a server and from what I have read, Flask and…
-
Can I use control center to add a start date to a project with dependencies?
We use control center to provision new projects. Our work plan template has a predefined project schedule using dependencies. Row 22 (after the navigation and summary rows) is "Manager set schedule", and is automatically assigned to the manager from the project intake sheet. The intent is for the manager to adjust the…
-
Automation Isn't Working
Hi! I am having trouble with my automation. I have a set of rules to assign colleague contact when certain criteria is met. I've noticed that one is not working and another is working too well where it is assigning this person to all my rows. Please see my screenshots below. I'm not sure where there error is in my rules.…
-
Programación de recordatorios automáticos para los revisores de pruebas
Buen día Comunidad, nos gustaría presentar una gran solución creada por uno de nuestros miembros @Neil Egsgard. Gracias Neil, por su excelente contribución a la Comunidad. Aquí hay una manera de crear recordatorios para los revisores de pruebas. Esta solución será: Enviar un recordatorio 5 días después de la invitación…
-
校正レビュアーへの自動リマインダーのスケジューリング
コミュニティの皆様、こんにちは。メンバー @Neil Egsgard 様によって作成された素晴らしい解決策をご提供させていただきたいと思います。Neil様、コミュニティへの素晴らしいご意見をありがとうございます。 校正レビュアーのリマインダーを作成する方法は次のとおりです。この解決策は： 最初の招待から5日後、もし誰も校正レビューリクエストに応じていない場合、リマインダーを送信します。 前回のリマインダーの5日後、もし誰も校正レビューに応じていない場合、リマインダーを送信します。 新しい校正バージョンが作成されたらリセットします。 役立つ修正には次のものが含まれます。 校正レビューリクエストに応答していない人にリマインダーを送ります。…