-
Gantt Chart Baseline - Added Functionality
On first glance it seemed like gantt chart baselines did exactly what I wanted to do - compare an "actual" start/end date to "forecasted" start/end date. When I actually went to go use it, come to find out all baseline does is take a snapshot of the dates/duration when the activity is first added and NO edits/modifications…
-
Building a formula based on a check box
Good afternoon. I am trying to solve a problem with our projects (we do not have resource management). for projects that are escalated we have a check box that our managers then see with a report due to the check box. Once the project is back on track, the check box is unchecked and the project goes back to the PM. I want…
-
Status Change within a Cell Formula where it moves it to the next stage if true
Below is what I need in a formula string to generate these items from a dropdown list within the cell. Cancel WT = Yes, Status = Cancelled If Demand Planning/AMT Input Complete (AMT) = True, Status = Finance to Add Cost If Finance Input Complete (Finance) = True, Status = IC to Set Up TO IF TO# (Inventory Control) is not…
-
Automation won’t stamp “Last Changed” date when Status is formula + linked cells
Hello! I’m trying to timestamp when the value changes in a Status column I've created, but the Status column is formula-driven and its inputs are linked cells / cross-sheet references from multiple source sheets. In my Master sheet, the Status column is a formula. The fields that drive that formula are not manually edited…
-
Sharing lessons learned - hiding rows & columns - replicating formulas across sheets - disaster plan
Warning! Long-ish post coming your way with multiple topics I wanted to share. Throughout, if I’m missing a functionality whereby I’m needlessly fretting, please, please let me know. Intro Hiding rows and columns administratively across 20 unique Sheets Porting in and out of MS-Word for large find / replace formulaic needs…
-
AVERAGEIFS or AVERAGE(COLLECT()) Help
Hi! I am struggling to get this formula to work correctly. The Smartsheet-AI generated formula is returning #UNPARSABLE and I am not too familiar with Average Collect. The goal: Average the column "Total Days Open" if the following criteria are met: column "Business Type" is NOT "retail" and column "Division" is "Northern"…
-
% Complete Column Appears Broken
The screenshot shows an assignment I am working on for an online class. I have a question about the lines highlighted in yellow. The "% Complete" column is supposed to show a calculation of the children's done percentage, I think. Am I understanding that correctly? If so, the Campus & Grounds line (NPI-052) showing 51%…
-
Copy rows to other sheet as values only?
What are some tips please to copy/move rows to other sheet as values only? Specifically, rows which contain column formulae. Is there a known workaround, or should I just use DataMesh? My main issue with this is that I can't copy columns containing column formulae. Thanks for your help, Matt
-
Personal Account for Fun (And Practice)
I am always trying to advance my skills and so, being the unapologetic Smartsheet buff that I am, I now pay for my own personal Smartsheet account to play around and practice my skills on personal projects. In my heart I would like to someday live somewhere else and to help me determine where…. I built a Smartsheet. Using…
-
Post Dashboard Demo Questions
I always get the same question after I do a dashboard demonstration. 😂 "How do I export this to Excel?" What are some questions you get after demonstrating a Smartsheet dashboard's capabilities?