I have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1. I've tried a couple of times and non of my rows are copied. To test it, I added to the same automation rule to not only copy my rows, but also send me a notification when this field changes. The strangest thing - I do receive the notification when the automation is triggered, however, rows are still not copied. (It's not due to space constraints in the destination sheet - it's empty) Thanks in advance!

@Stelina Todorova, Strange! If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Keep us updated on what you find out!

Automation 'Copy to another sheet' doesn't work

Answers

Christina09 ✭✭✭✭✭✭

01/15/21

Did anyone figure out a solution? I've tried a hidden column 0 to 1 to trigger it, but because it's still somewhat linked to the cell link, so it wouldn't trigger it.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

How to update certain cells in column based on one cell's input and other column's same ID #?
I have a very simple test script testing tracker located here: I want to be able to do one of the following: 1. Update the Status column for all testers with the same test ID to "Duplicate" once one person tests and puts "FAIL" in the PASS/FAIL column. 2. Do not copy defects to defect tracker sheet if one of the rows with…
Duplicate Formula
I have a Smartsheet which is fed from a form an Intake team is using to gather prospect information and we are having issues with duplicate entries. The sheet/form has a field for prospect first name and another for prospect last name which we would like to check for duplicate entries of. I created a column combining both…
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…

Automation 'Copy to another sheet' doesn't work

Answers

Help Article Resources

Categories