-
Insert date automation in different time zone
We have a column with a checkbox and when the box is ticked there is an automation in place to insert today's date in another column. This has been working perfectly until about 3-4 weeks ago and now if the box is ticked up until around 11am AEST it puts in yesterday's date indicating a timezone issue. Doesn't matter if…
-
Automated notifications are being sent to others at my company, but not to me. I am the creator of the sheet.
I'm putting together a spreadsheet and adding automations to send email alerts to individuals/groups indicated in specific fields once certain conditions are met. They appear to be working when my name is not listed in the indicated field, emails are being received by others, but not by me. I have checked junk mail, added…
-
Double entries via automation
I’m experiencing an issue with duplicate row copies in sheets where an automation copies rows from a source sheet to a destination sheet. The source sheet is used solely for collecting information through a form. Whenever a new row is added, an automation copies it to the destination sheet, where it is then monitored and…
-
Cell Automatically Updating without Automation & Dependencies are Off
Users submit a request by form to a sheet, it has a status column with multiple selections. Once the request is addressed, the status is updated by another user. The sheet is making a decision to automatically update that status when the row is added. There is also an unrelated date column in the sheet that the sheet chose…
-
Request an update displays no fields in the generated request
I have an automated workflow what has a step, 'request and update.' The step shows ALL FIELDS, but when the actual request is sent to the end user, there are no fields displayed. There are no locked columns or rows on my sheet. Both I and the end user are licensed users shared with the workspace and sheet
-
Date Automation Issues
I have the problem that the automation that puts a date in a DATE field, when it passes 6:00 p.m., sets it to the next day. My time zone is GMT-6, but it seems that the automation doesn't respect that setting.
-
Date & Timestamp a specific cell change
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…
-
Automation Workflows Not Functioning
Hello, We have several automations configured to copy a row to another sheet when specific criteria are met. Recently, these automations have been intermittently failing. For example, they worked this morning but stopped working this afternoon, and then they often begin working again the following day without any changes…
-
Automation - Run Now Function Missing
Has the run now function been moved? I no longer see it in the drop down menu from all my active animations.
-
Automation Alert links no longer bringing to specific row/cells
Hello, I've had an Alert automation on my project tracker sheet for over a year now set to go out every workday at 5am and email the contact in the QA column if the "Effective" Task is not checked/started and the Target Start Date for that row is within in the next 7 days. Usually it sends the sheet link to that row in the…