journal workflow

[meghant03]

I have a column called "Revenue Category" and all the values in it are supposed to start with "RC" and if there are other values in it like "Spend Category" items that start with "SC" or just other values besides "RC" I need to add a check that flags it for review. So how would I do this?

[ChrisTX]

Use a Formula tool, create a new field "Flag this record", data type Boolean, with this formula:

IF !StartsWith([Revenue Category],"RC") THEN 1 ELSE 0 ENDIF

Chris

[meghant03]

i don't want it to be replaced by "0" or "1" instead I need another column to show those values as it is. So like if a "Revenue Category" item has a value that begins with "SC" then I need another column called "review" that shows that "SC" value as it is in that column

[ChrisTX]

It will not be replaced by a 0 or 1.  Above I mentioned:  create a new field

Can you provide sample input data and expected output?

[binuacs]

@meghant03