Trending in Smartsheet Basics
-
How to Track Child (Level 2) Completed Rows Over Time?
I have many of these parent (Level 1) rows that are completed as the Level 3 rows underneath it are completed. Under the parent, Level 1, row, is a Level 2 row that is directly tied to certain Level 3 rows. I have completed dates on every row that is actually completed. How would I go about creating a chart that would show…
-
How to Child (Level 2) Data Complete Vs. Incomplete?
I have many of these parent (Level 1) rows that are completed as the Level 3 rows underneath it are completed. Under the parent, Level 1, row, is a Level 2 row that is directly tied to certain Level 3 rows. How could I create a Pie Chart displaying all of the Level 2 Rows Complete/Incomplete totals?
-
Error Message "Some cross-sheet formula can’t be updated"
I read that in order to fix this error I need to replace my Vlookups with index/match formulas. How does this decrease the number of references? I have checked all my ranges below, but I cannot find the error. Any thoughts? I need a date (located in first touch) returned from one of 10 workbooks, based on either the RA or…