Formula

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 Community Champion

03/27/23 Answer ✓

Hello @Trish
Change @ROW to @row
Hope this helps
Thanks,
Peggy

1 · Share on Facebook Share on Twitter

Answers

Peggy Parchert Community Champion

03/27/23 Answer ✓

Hello @Trish
Change @ROW to @row
Hope this helps
Thanks,
Peggy

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

03/27/23

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

Help with COUNTIFS with multiple criteria in same range, where to put the OR operator
This is a frequent topic in the smartsheet community, and I think I've read most of the responses, but I can't resolve it for my particular situation. : ( Mostly I get unparseable when I add my OR criterion. This is used on a project portfolio metrics sheet, where I want to count for each particular calendar year how many…
Formula help
This discussion was created from comments split from: Sequential numbering of duplicates.
Numbers Only Formula
Hello, I am trying to have the column "Order/Job #" automatically populate the 6 digit number of the parent row in the column "Customer or Task Name". So basically in the screenshot below, in the WHITE row, column "Order/Job #", it would say 661181. Basically, there will be multiple children rows under each parent, and I…