Formula

Options

Trish Mroz

Trish Mroz ✭✭

03/27/23 in Formulas and Functions

I am getting unparseable on this formula and I am stumped!

=([NB MONTHLY 2023]@row - [NB MONTHLY 2022]@row) / [NB MONTHLY 2023]@ROW

0 ·

Best Answer

Peggy Parchert ✭✭✭✭✭✭

03/27/23 Answer ✓
Options
Hello @Trish
Change @ROW to @row
Hope this helps
Thanks,
Peggy

1 · Share on Facebook Share on Twitter

Answers

Peggy Parchert ✭✭✭✭✭✭

03/27/23 Answer ✓
Options
Hello @Trish
Change @ROW to @row
Hope this helps
Thanks,
Peggy

1 · Share on Facebook Share on Twitter
Trish Mroz ✭✭

03/27/23
Options
Thank you, that did the trick!

1 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

One cell to multiple Formula
I'm hoping there is a formula that I can use that will read the first cell and input each thing individually in their own cell? Thanks
Cross-sheet & condition-based formula
Hi all! I need a formula that imports a reference number (auto-generated) from a column in sheet A (source) into a column in a separate Sheet B (destination), but only when a separate drop-down column in Sheet A changes to a specific value. Using a filtered report in lieu of Sheet B is not an option (at least not…
Not able to count total of different percentage fields?
I'm trying to get a breakdown of how many of each percentage group we received from this quiz and I've tried totaling from a percentage column as well as when the column is set as a decimal and I just keep getting 0 as a total, only the 100% has worked. Not sure if I'm just overthinking it or what, but here are some…