-
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…
-
Help Article updates: September 2024
Hello Community, We’ve published the following new articles: Create solutions from scratch or by choosing a template with Global Create Get started with Smartsheet Pivot App 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…
-
Please could someone kindly help me with this INDEX/MATCH/IF /AND Formula
Hello There Smartsheet Community Please could you kindly point me in the right direction with my formula? Sheet 1 Contains the following sheet references "Status" = Jira Status "MMP" = MMP I need to update the value of "Validation NL" based upon the following criteria: If "MMP" in sheet 1 matches "Req ID" in sheet 2 and…
-
Create Formula in Sheet Summary field to pull only Month from another Sheet Summary Date Field
I have a date field for projected go live date for projects in my Sheet Summary. I would like to add another field with a formula that will display only the Month Name in another field so that when I run the Sheet Summary report I can summarize projects going live by month. I would appreciate any guidance!! Thank you!
-
Can't figure out why one column in report has non-matching column name?
We've created a report consolidating 31 separate sheets each with a "Station" column. However, when selecting the columns, Smartsheet creates a second "Station" column that only references a single sheet out of the 31 source sheets. This column includes the help text "Includes 1 non-matching column name(s)". All "Station"…
-
Representing Multiple Phases on a Single Gantt Chart Row
Hello Smartsheet community, I’m working on a project where I need to visually represent different phases on the same row of a Gantt chart. For example, I have a project that runs in three phases: Phase 1: January to March (Yellow) Phase 2: March to June (Green) Phase 3: June to July (Red) Is there any native solution or…
