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.

DEPENDENCIES FORMULA IN TO A PROJET SHEET

Options
Edgar López
Edgar López ✭✭
edited 12/09/19 in Archived 2017 Posts

 

HELLO;

I HOPE YOU CAN HELP ME WITH THIS PROBLEM:

I NEED TO SCRATCH A FORMULA TO GENERATE DEPENDENCIES AUTOMATICALLY IN A PROJECT SHEET WITH THOUSANDS OF ROWS.

EACH ROW CORRESPONDS TO A TASK REPEATED RANDOMLY. AND MY PROJECT HAS MORE THAN 70 DIFFERENT TASKS, SO IT IS VERY LABORIOUS TO ASSIGN DEPENDENCIES USING FILTERS BY TASK.

ATTACHED THE LINK OF MY SHEET EXAMPLE IN WHICH I HAVE TRIED TO SOLUTION IT USING THE FUNCTIONS:

LOOKUP + MATCH

INDEX + MATCH

THANKS IN ADVANCE

http://publish.smartsheet.com/fb9df41f04754198b5e93de66eef8b54

<IFRAME WIDTH=1000 HEIGHT=700 FRAMEBORDER=0 SRC="http://publish.smartsheet.com/fb9df41f04754198b5e93de66eef8b54"></IFRAME>

DEPENDENCE.jpg

Comments

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

    question: task repeated randomly?

    I had a similar problem as one time, I believe. 

    Each project has a set structure of 5-10 tasks, all linked together, with modules of a fixed number that was determined on contract award. Depending on decisions made at project launch, the order was determined. Based on that info, the project was created using a script (outside of Smartsheet) and implemented in Smartsheet in less than an hour.

    It took a few days to design, implement, and test the script, but it worked and saved dozens of hours on each new project.

    Well worth the cost.

    Craig

This discussion has been closed.