Weird issue with copy row workflow

Options
L_123
L_123 ✭✭✭✭✭✭
edited 10/19/23 in Smartsheet Basics

I'm having an issue with data formats in a copy row workflow. I have a sheet that is functioning as a form. There is a list of data spread across rows and columns, and different people are updating a value in a single column. When that value is updated, the row is sent using a copy workflow to another sheet. On that row it seems to be using the normal "form" method of copying the data type from the previous rows if they match. My issue is that some of the values that are being input by the users are in percentage, some are in dollars, some are standard numbers, and smartsheet seems to prioritize the format of the rows in the destination worksheet rather than the source formats.

I have a somewhat workaround in that if I use a helper column with formatting in the destination sheet I can revert them all back to integer format, but that isn't optimal. I'd rather keep the source sheet format.

Answers