Reverse engineering a cell reference formula
Hi,
Smartsheet developed a solution for my current employer before I started here. I'm an Excel power user and in the process of becoming a SS resource for this employer. That said, I feel really silly but cannot figure out what's going on in this cell. It looks like a cell or column reference but the column doesn't appear to exist. Also, when I try similar syntax for a column that does exist (e.g. if I were to enter =[Status]#) I get an #Unparseable error.
Functionally, it's used to report out on a project portfolio dashboard the phase each project is in.
"Stage squarness" is a summary task in the project and there are some shenanigans elsewhere in the sheet with helper columns that are usually hidden involving looking at parent & child tasks. The names of those columns are "Function" and "Task Parent."
Just to add context, I've asked around here and no one else knows what's going on with it either. There are business users of the solution, but no one that's familiar with the infrastructure (functions, formulas, etc.) that are the engine driving the day-to-day business use of it.
Best Answer
-
Click this button.
This is how you reference a field in the sheet summary. 😊
Answers
-
Click this button.
This is how you reference a field in the sheet summary. 😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!