I’m using Microsoft Power Automate’s “Add a Row” action to populate a Smartsheet. Everything comes through correctly except the numeric fields I need to total later:
- In Smartsheet the values arrive as
'1 (text with a leading apostrophe) instead of 1 (numeric). - Because they’re stored as text, my column
=SUM() formula ignores them.
What I’ve tried
- Casting the value in Power Automate with int(), float(), and plain numeric literals.
- Wrapping the expressions in string() and concat() to remove stray characters.
- Sending a blank cell first and then updating it with the number.
No matter what, Smartsheet still treats the incoming value as text (either '1 or "1"), so the SUM doesn’t update.
Has anyone found a reliable way to make Power Automate insert a true number into Smartsheet, so the column’s SUM formula recognizes it?
Tips on expression formatting, column settings, or any intermediate steps that worked for you would be greatly appreciated!
