Workflow to change a cell value isn't working properly (changing the values I input)

I have several workflows to auto-populate a required reading column value based on what procedure is being performed. Most of them work just fine, but a couple of them are changing when they auto-populate in the sheet.

For example, I have the required reading for a specific task as "3941, 3987" but when the cell auto-populates it enters it as "39413987" in the sheet (missing the comma and space).

Any suggestions for how to fix this?

Find more posts tagged with

functionality

Automations

Workflows in Smartsheet

Accepted answers

All comments

ker9

Hi @Faye Kennedy,

Seems like a bug in the program, it returns text correctly if you have text (cat, dog) but not if you have numbers (3941, 3987). As a workaround, you can try adding an apostrophe (or another character) as the first character to get: '3941, 3987

Andrée Starå

Hi @Faye Kennedy

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

@Andrée Starå any ideas? screen shot is above

jmyzk_cloudsmart_jp

Hi @Faye Kennedy

A workaround would be to surround a number with quotation marks.

Then, if you don't want quotation marks, you can remove them by SUBSTITUTE() function.

I use a Sheet Summary field for a quotation mark in a formula.

Please take a look at the published example in the following URL.

https://app.smartsheet.com/b/publish?EQBCT=8d4e3c2151a346e1b171fc57a0f6a7d4

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.