Page 6 - Customize-Project-Plan-by-tailoring-Smartsheet
P. 6
Customize your Project Plan
by tailoring Smartsheet
26.1. VISUAL INDICATORS (E.G., TRAFFIC LIGHTS) ................................................................................................... 72
27. CRITICAL PATH .................................................................................................................................. 80
27.1. CRITICAL PATH ......................................................................................................................................... 80
28. RESPONSIBLE & ASSIGNED TO … ....................................................................................................... 82
28.1. RESPONSIBLE & ASSIGNED TO … .................................................................................................................. 82
29. FORMULAS (IF, VLOOKUP, …) ............................................................................................................ 84
29.1. FORMULAS .............................................................................................................................................. 84
29.1.1. IF ..................................................................................................................................................... 86
29.1.2. VLOOKUP ........................................................................................................................................ 87
30. VALUE LIST ......................................................................................................................................... 97
30.1. VALUE LIST .............................................................................................................................................. 97
31. FORMULAS BY @ROW ...................................................................................................................... 98
31.1. FORMULAS BY @ROW ............................................................................................................................... 98
32. CONVERT TO COLUMN FORMULA ..................................................................................................... 99
32.1. CONVERT TO COLUMN FORMULA ................................................................................................................ 99
33. INSERT IMAGE ................................................................................................................................ 100
33.1. INSERT IMAGE ........................................................................................................................................ 100
34. CONCEPT OF PLANNING & MONITORING ....................................................................................... 101
34.1. CONCEPT OF PLANNING & MONITORING .................................................................................................... 101
35. PROJECT STATUS "HOW'S THE PROGRESS?" ................................................................................... 103
35.1. PROJECT STATUS "HOW'S THE PROGRESS?" ................................................................................................. 103
36. PARENT AUTOMATICALLY CHECKED OFF ........................................................................................ 106
36.1. PARENT CHECKBOX CHECKED IF ALL CHILDREN CHECKED OFF ............................................................................ 106
37. PARENT AUTOMATICALLY COLORED ............................................................................................... 108
37.1. PARENT ROW AUTOMATICALLY COLORED .................................................................................................... 108
38. FORMATS (CURRENCY, DATE, …) ..................................................................................................... 111
38.1. FORMATS (CURRENCY, DATE, …) ............................................................................................................... 111
39. VIEWS (GANTT-, GRID, CARD, …) ..................................................................................................... 112
39.1. VIEWS (GANTT-, GRID, CARD, …) .............................................................................................................. 112
40. UNDO / REVERSE ............................................................................................................................ 114
40.1. UNDO / REVERSE.................................................................................................................................... 114
41. SAVE, SAVE AS … (BACKUP) ............................................................................................................. 115
41.1. SAVE, SAVE AS … (BACKUP) ...................................................................................................................... 115
41.2. "DATA SAFETY" ...................................................................................................................................... 117
© Hans Porzel, 10/2025 | CAPM® (PMI), PSM I® (Scrum.org), Smartsheet Prod. Cert® 2020 Page 6 / 209 pages
