-
'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…
-
Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…
-
Introduction
Hi all, my name is Vesna and I work as a senior project manager in regulatory affairs for medicines. I am so excited to use the Smartsheet!
-
How do I get a column that shows the automated % complete for each activity?
I am struggling to get any formulas to work, I need a column that shows the percentage complete from the start date to the finish date - shouldn't be that hard but this is causing me so much grief. Every formula I find doesn't seem to work and I am not savvy enough to know how to update the formula so that it can work.…
-
using intake form, data populates and emails me but no project is created
Title is kind of the question — why wouldn't the emailed content, a copy of data I entered to the Intake form, also create a new project on the project sheet? Thank you.
-
Introduction post
hi all, my name is Vesna and I work as a senior project manager in regulatory affairs for medicines
-
HTTP Request for Automations
Developers could gain a lot more access if you allowed for HTTP requests within automations.
-
I am trying to find a value in a table based on 2 criteria.
I am trying to find a value in a table based on 2 criteria. One of the values is dynamic from a drop down menu, while the other is static value in a column. The first value is found in column "Building type" and the other is found in Resource type. The table I am referencing is also shown. The result would be shown in the…
-
Notifications work for all but one person
I have a simple automation setup that if someone is added to a specific column that triggers the notification to run to send an automated email saying the person was assigned something and should check the sheet. Everyone except a single person is receiving these emails. I have checked the person's smartsheet account and…
-
How to export / import PDF document mappings
Hello. Is there a built-in mechanism by which I can export PDF document mappings from a sheet, and import into another sheet? (without using the API) As it stands, if I clone a workspace folder, the automations are copied to the destination, but PDF document mappings are not. Thank you, -tom