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?
I'm creating a formula and I need to reference the current row of the cell I am in. Does Smartsheet have a functional similiar to MS Excel's row() function?
Thanks,
Judy
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
