-
Formulas and Newly Added Rows
Hi, Our case application requires a lot of movement of rows between sheets, and I am having an issue with Formulas not automatically applying to newly added rows which necessitates going into the sheets and manually clicking and dragging the formulas to newly added rows from the rows above (time consuming with multiple…
-
missing image links in alert someone automation email
Help, We are receiving these emails in outlook 365 with 3 issues see the screen shot below: This seems to be a link to the smartsheet that triggered the automation. Not having the image display looks poor and I do not want the link to the smartsheet on the email (I noticed that the request an approval automation emails…
-
Automated Updates
When I send and update request to more than 1 person - I understand I can add an Action to lock the row such that subsequent updates fails. 1) Is it possible to capture who updated - into a cell ? Writing a comment shows who updated - so I assume somewhere this information is collected. 2) Would subsequent updates be…
-
Automation Based on Number Formula
I have a Number column with a formula as below, where the number keeps changing ( where [column] is a date column ) =TODAY()-[column]@row I want to send reminder alerts and update requests automatically as the number keeps changing ( say 1, 5, 10, ... ). Will this be caught in a Automation Trigger such as Row Changed…
-
Do daily update requests get sent out during non-workdays?
We have an update request that will ask foremen to update the percent of a job they have done. The update request is set to trigger daily by using the date trigger option in the automation menu. Would these requests be sent out during non-workdays?
-
Automation not following Conditions set
I'm not sure what I am doing wrong with my automation. I have an Update Request and an Alert automation set up as one Workflow to send out if an upcoming task is less than 70% complete and is not a Parent Row. The problem is I continue to get notifications for rows that are 100% complete and rows that are Parents. What am…
-
Automation emails not sending?
I"ve created an automation that I was expecting to send an email w/ form to folks -- but it's not sending to folks. I see it in under my notifications but not via email.
-
Copy Row Issue
Just had an issue where my copy to workflow only worked on 2 rows out of ~15. This is not a new workflow, and has been tested and functional over 30 times, and no one has accessed or changed anything in the sheet other than me. Is anyone else having any issues with this? I really need the workflow to be trustworthy for…
-
Placeholders | Still batching Emails
Hi team, I'm using Placeholders in a workflow to generate individual emails for an update request. Although the same individual received the update, they will forward as needed, so I need to ensure each update request for the day doesn't 'batch'. I've done a small test and had no issues, but when i moved into the live…
-
Is there a way to Force a Date or Time?
I am trying to have some date fields auto-populate based on some restrictions. Date Columns 2, 3 and 4 would be dependent on Date column 1. For example: An Inspection must always occur at least 2 days after Work Start. If I enter Work Start to be 1/20/2020, I want the Inspection Date to auto-populate to 1/22/2020.…