-
Automation Email in Two Different Formats
I saved a sheet as new, in a new workspace, and my automation is working differently on the original sheet vs the Newley created sheet. The automation is exactly the same (Send x row in an email with x specific columns to x person) When I do it on the original sheet it gives me the full row horizontal view that is neigh…
-
How to automate or move cell values when a date is in the past week?
Here is a tracker of a 10-weeks look ahead of number of hours to spend in project from Monday-Friday which are highlighted in blue cells. The Start Week and End week changed if a date is based on current week. Which means 9-Jun-2024 will be the current week by next week , correct? The problem now is the no. of hours is…
-
Automating a change in value when a condition is met at another sheet
I have two smartsheets with part numbers. When a request for a part number is made, I want to decrement the number on hand that is kept in another smartsheet. How can I link the two smartsheets and automate the mathematical subtraction?
-
Automation: Trigger only when an attachment is added
In sheet automation, it seems that you can get an alert if an attachment is added, but only if rows are added or changed. We want an alert when an attachment is added even if no data is changed. How can we accomplish that?
-
Nonsense letters - Mapping PDF doesn't pull information from form/sheet correctly
I am trying to use the entries from a form to auto-generate certificates of completion. It seems I have everything set up correctly (Fillable PDF mapped, set up in the workflow, correct column naming etc), however it generates nonsense letters for the entries. Any ideas on what I should troubleshoot to fix this?
-
'Record a date' automation action does not recognize date column
Hi, I have a date column in a sheet (which is used for schedule calculations, so the type cannot be changed); I am now trying to add an automation to fill in this column if another changes and this is blank. However, when I try to deploy the 'Record a date' action, it says that there are no date columns…. How do I resolve…
-
Automatic Information PDF sent to submitter of form
Hello! Apologies if this is answered somewhere already, but I was having a hard time finding exactly what I was after. I have a form I am sending out for applicants to submit. Is there a way for these applicants to automatically receive a PDF document after submitting the form? Currently in workflow automation I have it…
-
Is there a way to convert a large number of contact cells at once?
I have over 5000 rows in a sheet that has been exported from ServiceNow. Every row has a contact cell that is filled out with a raw name, no company email. Is there a way of converting every cell into the respective company email for that person at once? The manual method, typing their name and selecting the pop up, will…
-
自動化（Automation）での更新依頼メールから”シートに移動”が表示されないようにしたい
こんにちは。いつもお世話になっております。 自動化の機能を使って、シートの共有者（＝担当者）に内容の更新依頼を定期的に出しています。 担当者へはSmartsheetから自動でメールが届き、「リクエストを開く」のリンク先の更新フォームから情報の更新をお願いしています。 このメールには「シートに移動」というリンクがあるのですが、このリンクを表示されないようにする方法はありますか？ シートには担当者には共有したくない情報も含まれているので、担当者へはそれら情報を除いたレポートを作成して共有しております。 一方で、シートから担当者とコメントのやり取りやレポートからの情報入力をしてもらいため、シート自体も担当者と共有をしています。…
-
i am trying to create an automation but cant find the any the sheets on my workspaces
