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?

Judy Nannini
edited 12/09/19 in Archived 2017 Posts

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?





  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



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



  • 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
    J. Craig Williams ✭✭✭✭✭✭



    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


    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.  





This discussion has been closed.