Smartsheet Automation Problem

Here is a very simple automation which says that if a row is added or changed, and the value of Status is blank or 'On Hold', then change it to 'Backlog'. Now I add two rows, first with status blank, and second with status 'On Hold'. The automation changes the value of second row and not the first.

Then I changed the automation, but still the issue persists. When I add two rows, first with status blank, and second with status 'On Hold'. The automation changes the value of second row and not the first.

Anyone has an idea why is this so? Is it a bug?

Find more posts tagged with

Accepted answers

Adrien Leduc

I think it's because the value of your first row doesn't "Change" to blank, The row is added (automation sees that), but the field is not changed ("When Status changes to").

You could remove the "status" in the trigger and just says any row added or changed, then keep your filter as in the 2nd screenshot and that might work?

All comments

Adrien Leduc

I think it's because the value of your first row doesn't "Change" to blank, The row is added (automation sees that), but the field is not changed ("When Status changes to").

You could remove the "status" in the trigger and just says any row added or changed, then keep your filter as in the 2nd screenshot and that might work?

Amark

I agree that its happening because the value of your first row doesn't "Change" to blank

Best option would be to Split into 2 workflows.

Workflow 1:

Trigger: When row is added
Condition: Status is blank
Action: Change cell value to Backlog

Workflow 2:

Trigger: When rows are changed
Condition: Status is one of "On Hold"
Action: Change cell value to Backlog

AdnanM

@Adrien Leduc your solution has worked. Thanks.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.