-
Has anyone used Smartsheet for production resource scheduling?
My company is still relatively new to Smartsheet. We have a project template that is working well for us. However, we also would like to also find a way to use Smartsheet to help us plan/schedule our production resources. We want to be able to line up projects, machine hours, and labor (non smartsheet users) so that when a…
-
Dynamic Unique List?
Is there a formula or work around to return a dynamic list of unique values from one sheet to another? I'm attempting to create a "Count" of projects by project manager from a project intake sheet. I'd like the report or sheet to dynamically update if a new hire PM is added to a project on the project intake sheet.
-
Help Article updates
Hello Community, We’ve published the following new content: Collections in workspaces Learning Track Resource Management in Smartsheet To view the entire catalog of help articles, visit the Help and Learning Center. Were the articles helpful? Let us know by providing feedback at the end of each article.
-
Displaying all unique values on a new sheet from columns on a reference sheet - Help
We have a form set up for collecting information from scientists performing runs by different projects. We need to be able to supply material lot information to clients separately by project numbers. I tried to use the following forums to perform the index/collect/distinct formulas which didn't work for me when referencing…
-
Match Formula Help
I have created two sheets and in need of some help with a formula. Sheet 1: Vendor Directory (with columns "Vendor ID", "Vendor Pin", and "Vendor Verified"). Sheet 2: Vendor Verification (Which vendors will populate with their "Vendor ID" and "Vendor Pin") When a row is entered in Sheet 2 the formula should look at sheet 1…
-
Are there any businesses located in Christchurch that use Smartsheet for PPM?
Hi, I'm new to Smartsheet and am interested whether there are any businesses located in Christchurch, New Zealand, that make use of Smartsheet for portfolio and project management. I think this is the solution I've been looking for and would like to connect with local users to speak in person about the capabilities before…
-
Questions about the form
Hello, How can I create a form that edits a line instead of creating a new one?
-
Formula Assistance 🙏
I have the following data set: Wellness Annual Total Wellness Expense Wellness Remaining Education Annual Total Education Expense Education Remaining $1,000 $500 $500 $5,000 $4,500 $500 I am trying to write a formula for the wellness remaining column, but I have a rule I must follow that is giving me a headache for the…
-
Smartsheet API and pyinstaller ImportError
I have a python script that takes a csv file and adds the rows into Smartsheet. When I run my code through the command line the script runs perfectly. However, when I created an application using pyinstaller for this script, I am getting an Import Error! Could not load api or model class Sheets Is there a solution to this?
-
Report information is not displaying on dashboard all of a sudden
I have built a dashboard that houses a number of reports, displaying where production is at which stages and the number of items being built. It recently stopped populating the report data and appear on the dashboard. When I click on the reports it brings me to them and the data is there and operational. I have attached…
