Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
is there a row() function in Smartsheet similar to Excel?
Comments
-
No.
Depending on what you are trying to accomplish, there might be a different way to solve it
Craig
-
Hi Craig, I'm trying to find a way to identify where my tasks are a dependency for others without filtering for it one by one. and how many other tasks are dependent on a particular task, hoping to identify the high impact tasks that we must keep an eye on.
Any suggestions for me?
-
Judy,
Very common problem.
On the GUI side, the problem is parsing is a nightmare. While there are rules, they don't result in a strict order.
A task could have these (among others) as a dependency:
9, 11
9FF, 11
11, 9FF
9SS, 11 + 23d
etc..
which results in being dependent on tasks in row 9 and 11, but all in different ways and more importantly for this discussion, harder to extract with the GUI.
While the back end has the same format, a parser would be much easier to write to use the API (Smartsheet has one or Preds would not work)*
For simple dependencies (all SF, no more than 3), there is a GUI solution.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives