-
can you set up weekly reminders for a date that has gone in the past (off a cell in the sheet)
Im looking to set up a reminder automation that will send out reminders on a weekly basis if tasks are not completed by a certain date. In my sheet there are numerous dates and they are pulled in from formula (dynamic) meaning that i need to pull it off a specific column / cell in the sheet. although the automations allow…
-
Removing the "Comments" tab from exported Excel reports
Hello, everyone! I have an automated Report that exports as an Excel file attachment to a team leader every week. He uses this report to upload info into a different system (not project management, a totally different thing). Each report comes with the report on one worksheet tab and a second worksheet tab called…
-
Merged: Lock Specific Cells
This discussion has been merged.
-
Data Shuttle - Notifications if Unique ID is Missing?
Hi all! I'm setting up a data shuttle to automatically update our records when we receive inventory reports from a third party vendor who manages our warehouse. The trouble is, we've noticed that some of our items have fallen off their reports, and we need to keep an eye on this week over week. I'm trying to see if there…
-
Scheduling Emails
I am running automations to send emails when text or a checkbox is active in a cell sending row information to different people, there are no attachments on these emails. I would like to know if I can schedule the emails that are triggered for once or twice a day. This will allow for fewer emails when a lot of rows are…
-
Auto-Assign Task in Board View Based on Filtered Individual
Hi everyone, I’m looking for a way to automatically assign tasks to an individual when a new task is added in Board View and a filter is already set for that person. For example: • I have my Board View grouped by Assigned To. • If I filter the board to only show tasks assigned to me, and then I add a new task, I’d like…
-
Any way to update formula criteria with drag-fill
Hello, I have a sheet with around 3000 rows all of which have a date received and I am trying to count how many were received per week. Currently I have a helper column which has the week number (1-52) and have =COUNTIF([Week number]@Row, =1) which works but I am wondering how to then extend the formula to automatically…
-
Automation to record values from one smartsheet onto a new row on another smartsheet once a week?
Hello, I imagine the answer(s) to this question already exist but I haven't had luck finding them, please point me in the right direction, here's my situation: I have a Smartsheet ("sheet 1") that my team records numbers on during the week every week. "Sheet 1" has 100 rows, and there's one column ("column x") in "sheet 1"…
-
If I lock columns down so that users cannot edit them, can I still use the "Copy Row" automation
-
SmartSheet Automation - Notify Emails not triggering at all
Hi all, I've ran into an issue where on all of my sheets I have that's shared out to dozens of users and are on the distribution list to receive emails based on rows added/changed with criterias to trigger email sendouts to them. This has been working fine the past 2 years. However, as of 2 days ago all emails have stopped…