{'fraction_non_alphanumeric': 0.01858736059479554, 'fraction_numerical': 0.0, 'mean_word_length': 5.2153846153846155, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
AUTOMATE TASK’ DEPENDENCIES COMPLETION TRACKING IN SMARTSHEET

Smartsheet is the well-known project management application. It helps managers to develop project plans and track their execution. When project’s tasks have many dependencies, a manager often has to scroll the plan up and down for visual assessment of completion statuses each of them. It needs many efforts and time.  
The article proposes a solution to automate the dependencies completion tracking in Smartsheet for a specific task. The solution allows tracking different types of dependencies for a task: completing direct dependencies from other tasks and completing dependencies for all of its ancestors. The algorithm of the solution, Smartsheet’s functions for its implementation, and the screen forms of the obtained results are given.