Workflow- trigger and output inconsistencies

Morganch

I've built out the following workflow to notify our PMs of any newly inserted row AND change cell value on two columns in added row.

1. The workflow is not sending notifications during my testing, but has been populating the formulas as intended when I add rows to the sheet.
2. When I manually run the workflow and notify myself, instead of populating formulas as expected, they are filled in as text- the notification does however trigger.

Is there a reason why this workflow is not functioning as expected?

Ryan Sides

@Morganch

Hey Morgan, your newly added rows are getting their formulas from the rows above them (not from the automation). Smartsheet auto populates formulas in new rows without the Automation you setup.

The automation you're looking to use, doesn't populate formulas, only text. That's why your formula is being shown as text when the automation runs.

Mike TV

@Morganch

To add to what @Ryan Sides provided, formulas will copy to newly added rows if the 2 rows above the new row both have the same formula. This way you don't have to have a column formula for a new row to have a formula in it automatically.

Morganch

@Ryan Sides @Mike TV

The formulas are not copying into newly inserted rows on the sheets I'm testing, I've checked this dozens of times now with the same result.

I've been having inconsistent results with getting the notifications to trigger independent of the formula copying as well.

Mike TV

@Morganch

Insert row is different. If you insert a row, it won't inherit the formula. That cell will be blank.

Ryan Sides

@Morgan

can you make your formulas column formulas? Or is there a reason you don’t want that?

Morganch

@Ryan Sides Thanks for the suggestion! That will work for one of the formulas, unfortunately there are a mix of formulas in the Approval Status column.