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.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives