-
How will the new email OTP login method impact Live Connector?
How will the new email OTP login method impact Live Connector’s 32-bit ODBC connection?
-
How to edit filter to include YEAR function
So I had this formula created and its searching by a couple of different metrics to gather the average of a column but only via the supervisor name for another column. Silly me forget we only need to spit back data from 2024 as the sheet collects multiple years worth of data and my brain is really struggling to add this…
-
Why does Smartsheet add a single quote before an integer that begins with 0?
A single quote keeps getting added when a 0 precedes an integer regardless of the entry method for the cell’s value (e.g., when the values are imported into Smartsheet from an Excel file, when the values are copied and pasted into Smartsheet or when the values are manually entered). Example: 099999999 changes to ‘99999999…
-
Hide Blank Columns in "Print" view
Smartsheet already gives the ability to display hidden columns when printing, but it'd be REALLY nice if you could hide columns that don't have data in them. If you have a huge form (50+ columns) with a bunch of conditional logic, there's going to be a lot of blank columns in any of the sheet views currently available.…
-
Formula previously working (along with others) and not now
Hi all I have this formula in one of the summary sections for tracking the SLA of job completions as part of a number of others, mainly for the creation of graphs and percentages etc and a lot of them seem to have stopped working. They now say #INCORRECT ARGUMENT SET. None of the references have changed and I'm so confused…
-
I Need Help with IF Formula for Progress Bar Symbol Column to Function Accordingly
I'm trying to set up our Carpentry Shop's Progress Bar by how many hours they've used from the total hours they were assigned to use for the project. The following screenshot shows an example. The carpentry shop was assigned a total of 80 hours to use. So far they've used 40 hours. The progress bar's formula then updates…
-
Dropdown List Per Cell Using API?
I have been doing a ton of research on how to do a dropdown at the CELL level, instead of column level. All signs point to this being a lost cause, as the feature has been being requested for 5+ years now. However, one forum response indicated this is possible through API. Does anyone know if this is the case? If yes, how…
-
Over allocated resources, no red flag alert
I allocated 100% allocation for the same resources in both projects as an example, projects CMDB and GXP Shutdown. How come I didn't see the red flag in column "Risk" to indicate that the resources are over allocated. Please help. Thanks, Kathryn
-
Auto Generation of Crossreferenced tables
Topic: New Sheet Row Generation with selected data from a source Sheet with data linked. FYI: I posed this @ Product Ideas too. If you are used to ERP linked data tables you may have explerienced the need to get similar benefit in Smartsheet. We are in the need to generate a new row in a "destination sheet" triggered from…
-
Smartsheet Enhancement Request: Snapshot/Print Workflows
I have made several workflows that were fairly large for different applications in smartsheet. I would like to have a simple function to print/pdf the workflows so as to see all of one at once. This would help me with design, troubleshooting, and communicating the process to those involved in it. I have submitted an…