-
Include Column Origin in Properties
This request stems from my copying and moving rows from sheet to sheet. It would be very helpful for me to click on a column and see where the column originated from (Sheet name). If it was copied/moved and carried over from a different sheet, or if it was created within the current sheet. I'm running into very frustrating…
-
Automation that alternates assigned contacts each time a row is created
I'm trying to figure out how to create an automation or formula where it will automatically assign from two or more contacts when a new row is created. It would also need to alternate or go to the next contact in a list. For example, I have an "Assigned to" column and in that column would be 2 names (A and B) and when a…
-
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"…