-
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…
-
Format Parent Rows Only with 'Helper' Columns Not Helping...
Hello, New to Smartsheet and trying to learn! None of the posts on the community have worked but I believe this is a basic question. Using indentation, we're creating parent/child rows for individual projects. I simply want the parent row to be able to highlight a color for that whole row once created to visually separate…
-
Problem with a form
I have a form, when the requester clicks send, it appears that there was a problem submitting, but the data is inserted into the spreadsheet, is this some type of visual bug? If I recreate the form does it still give me this problem? Well, I already did it and it happened to give me the same error. Anyone have the same…
-
Rolling "instagram" Style View
Current Smartsheet views are limited to Timeline, board, grid, card, and calendar views. I would like a "instagram" style view which would incorporate photo and video attachments with additional info below from the sheet. This would be extremely helpful when using forms to generate content for media and communication…