Can "@row" be used in the Intake Sheet Summary page calculation?
Kathy PPT
✭✭✭✭
Hi,
Just need a sanity check please.
Can @row be used in the Intake Summary page calculation? I assume it won't work because it is a summary. However, [field]x:[field]xx (where x is the first row to consider and xx is the last) works.
Tags:
Best Answer

@row can't be used in a summary field because there is not row for it to reference. @row always references the row the formula is actually on.
Answers

@row can't be used in a summary field because there is not row for it to reference. @row always references the row the formula is actually on.

Thanks Hollie!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!