I have a multistep scenario, I’d like to update a cell by getting the value from the cell (I can get it from a previous step) and then subtracting one from that value.
I’ve tried this:
But I get NaN in Google Sheets, so I guess it’s not detecting the formula or something.
How exactly can I make this happen?
Welcome to the Make community!
Your math brackets are currently just text.
You’ll need to select them from the variables panel, or type them like this:
{{(}}
{{)}}
samliew – request private consultation
Join the unofficial Make Discord server to chat with us!
And you don’t even need the precendece parenthesis, so they can be removed.