-
Battle over Sorting and Filters
Greetings, We are starting to use Smartsheet heavily in a lot of our processes. We deal with contractors on a daily basis. We have several groups of contractors that view one master sheet and each of their own set of columns they review and work with. They may not directly interact with other parts of the master sheet, but…
-
Multiple section in a dropdown list?
Hi, Is there a way to select multiple items in a dropdown list? Here is the scenario i am trying to solve for. A product roadmap project may can be related to multiple products. I currently have a dropdown list column for products and each row is project. Currently i can only select one product per project. ideally i would…
-
automatically export and then delete rows
We use SmartSheets to collect a large amount of data using a form. We reach the Smartsheet size limits almost weekly. Currently we log in each week, export the data to excel, and then delete rows based on a date criterion. I have looked at Zapier. It looks like I can have it email me the data in excel but the free version…
-
Reaching for Specific Information Return
I am trying to use a set of sheets for material tracking from various suppliers without actually having to have my employees use several sheets to do it. I am wondering if there is a way/formula to look through a specific column for a supplier name, and in whichever row it finds said supplier it then outputs that entire…
-
Planning : expected vs reality
Hello ! Does anybody know if how to show on the same line of the Gantt mode, the expected planning and the reality. Here attached is an example of what I need. Thank you for your help !
-
Cross-sheet formulas
I love that we're now able to use ranges from other sheets in formulas. I just updated a summary sheet so it uses formulas linked back to worksheets for each member of my team, rather than having the formulas on each team member's sheet and linking from there. I have a couple of questions about the best way to use the new…
-
"The source data for this chart has changed" - Charts with Zero Values
Hello. I have noticed that charts within a dashboard do not display and throw up a message: "The source data for this chart has changed" when they are pointed at sheets or reports where the value is zero / 0. This is problematic for me since I have created a dashboard for a template set of sheets and reports, and…
-
Looking for Smartsheet Consulting Expertise - Charlotte NC or Atlanta GA
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
-
Formulas and Calculations
Duh!! I figured it out. It was simple. Dennis
-
Customizing Gantt Charts
I am brand new to SmartSheet and my team is primarily interested in finding a Gantt Chart / Timeline maker. I'm hoping the community can help me figure out the following: * Is it possible to make the gantt ribbons flat, without arrows? * Is it possible to show the task name on the ribbons? * Is it possible to make the…
