Sign in to join the conversation:
Is there a way to exclude tasks/rows from the % Complete Calculation?
Yes. You would use a COLLECT function (or SUMIFS or AVERAGEIF depending on your setup) within your formula used to generate the % Complete to specify which rows to INCLUDE. You will need to be able to specify some kind of identifier in the formula for it to compare against unless you wanted to create a long, tedious, rigid, manual formula.
When I use the zoom-in option, I can only see the day names but not the specific day numbers. I need my team to be able to see the exact dates for the tasks I have scheduled.
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…
