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
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>
Comments
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives