Automation change cell value no longer being translated to a $$ value?

Hi,

I've noticed this issue in two of my smartsheet processes.

I have an automation set up as follows: "When rows are added are changed and [Column A] changes to [Any Value], change cell value in [Column B] to "60" "

I then set column B to be $ currency format. Up until recently, "60" changed to "$60.00" without issue but in the last month or so "60" is now remaining "60" (and is being recognized as text, not a number/currency).

As a result, another column that had a [ColA]+[ColB] sum formula is resulting in 60[ColB], not two numbers being added together.

I worked around it in one sheet by using Datamesh to import a value of "$60.00" from another sheet instead of using the automation, but that won't work for my second sheet, and now that I know it's the same issue across multiple sheets I'd like to know what I need to do to get the cell to show as $60.00 correctly without using roundabout workarounds.

Thank you!

Find more posts tagged with

Sheets

Formulas

functionality

Automations

Accepted answers

All comments

Paul Newcome

Can you provide a screenshot of the automation?

JessN

Hi Paul,

I am also including a screenshot of what the Lockout Fee column used to look like vs what it looks like currently (the last four rows). The first instance of an issue was submitted on 9/10/25. I'd have to look back to see if there are earlier occurrences on the other sheet.

I did attempt changing the cell value to $60.00 (writing the dollar sign and .00) but when I last tried that still imported as text instead of a number/currency.

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.