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
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.
