is there a row() function in Smartsheet similar to Excel?

Judy Nannini

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

J. Craig Williams

No.

 

Depending on what you are trying to accomplish, there might be a different way to solve it

 

Craig

Judy Nannini

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?

J. Craig Williams

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