-
New Function - "PREDECESSORS"
"PREDECESSORS" = similar to current "SUCCESSORS" function but returns the row references for predecessor tasks in dependency enabled project sheets. The values returned should be referenceable values in other formulas, e.g. omitting the SS/FS/FF task constraints in the dependency column so index/match formulas can beβ¦
-
Feature Request: Include Support for Cross-Sheet References in Global Updates β Control Center
Description: Currently, Global Updates in Control Centerβspecifically the Find and Replace function for formulasβdo not support updates when those formulas involve cross-sheet references. As a result, Admins are required to manually update each individual project sheet, which is time-consuming and labor-intensive,β¦
-
Data Shuttle - Update dropdowns on multiple sheets
I have multiple sheets where I update the dropdowns all based on the same information. It would be great if I could create a single Data Shuttle job that would update all of these sheets at the same time. Having to create dozens of jobs to do the exact same thing, just to a different sheet, is burdensome and confusing toβ¦
-
Automatically Sync Reports When a Source Sheet is Renamed
Feature Request: Automatically Sync Reports When a Source Sheet is Renamed in Smartsheet When a report is grouped or sorted byΒ Sheet Name, renaming a source sheet doesn't immediately update the report. The new name only appearsΒ afterΒ a change is made and saved in the sheet. Until then, the report continues to displayβ¦
-
Export Column Properties
I would like to be able to export the column properties of a sheet. It would be incredibly beneficial to be able to export the extensive structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values onlyβ¦
-
Function() or @argument for "currently logged in user" for use in Sheet formulas
I would like there to be a function() or @argument (e.g., User() or @user, perhaps?) that I could use in Sheet formulas that would evaluate to the "currently logged in user". This would enable more flexible Filters in Sheets that could be supported by Helper columns for evaluating logic against multiple multi-select Personβ¦
-
Enable Clickable Hyperinks in Smartsheet Forms (Android Mobile App)
Hello Smartsheet Community, We've observed that hyperlinks included in the "Form Description" and "Helper Text" fields of Smartsheet forms are not functional within the mobile app. While these links operate correctly on desktop browsers, tapping them in the mobile app yields no response.β This limitation significantlyβ¦
-
Way to calculate parent row % Complete in other columns (like % Complete) for SPI.
We have a Planned Value column that is based on Start and End dates and a SPI column that is based on Planned Value and % Complete. Our Planned Value column is used to show what the task % Complete SHOULD be for the project where the % Complete is what the ACTUAL % Complete for the project is. The SPI uses %β¦
-
Dependency columns: Automations or Formulas in Start / Finish & Duration Columns
With so many posts about this why has this feature not been added or fixed? The fact that this is not a feature in Smartsheet makes it extremely difficult and inefficient to accurately determine schedules. We are utilizing Smartsheet to build out our schedule the production and forecast the completion of our products. Allβ¦
-
export to .MPP file
Hello, I would like to be able to export directly to .MPP file for Microsoft Project instead of, or in addition to, .XML file. .XML files cannot open directly in Microsoft Project, instead they have to be imported in. This adds and extra step for clients who may not be as tech savvy and who want us to send them a weeklyβ¦