Best Of

Hi!

I wanted to submit a feature request to add to Smartsheet. I organize a lot of documents that are displayed in all caps [Ex. PLEASE SUBMIT ADDITIONAL NEEDED DOCUMENTS]. I have noticed there is not an action/formula available that changes the text to PROPER like in excel [Ex. Please Submit Additional Needed Documents]. I believe this would be a great function to include/add!

Better yet, allow users to add themselves.

When a cell is bringing data from another cell using a formula, it can only show the text, but the hyperlink of the other cell is not clickable in this cell. Looking fwd to be able to click the hyperlink in the formula cell as well.

This needs to be added, a glaring lack of functionality within smartsheet. Excel has had the HYPERLINK function for decades.

Nearing a year since this was suggested….any word from PM's on if this will be supported? @Genevieve P.

This issue is causing major problems for our group. Without it, I'm looking into users clicking on a form to get the benefit of conditional formatting, then feeding that value back into the original sheet.

Hi @Genevieve P.,

I believe most of us have come to this page because our use cases extend beyond basic data collection and updates, which are the limits of Forms and Update Requests do.

Many demos showcase Dynamic View with WorkApps, where staff easily navigate workflows. However, real work processes often branch, requiring Dynamic Views to adapt with real-time logic to maintain workflow continuity and productivity. This ensures user confidence in the tools and platforms.

Use Case: Annual Budget Requests, Roll-Up, Review, & Approval:

1. Teams submit funding requests
2. Division heads review, assign statuses, adds comments, and loop in others as needed
3. Budgeting office reviews, adds info, and forwards to leadership
4. Org leadership reviews, assigns statuses, may make changes, and sends back for review
5. Divisions review, respond, and may negotiate additional changes
6. Finalized budget proposals are shared across the org, with only relevant data visible to each group

Assumptions:

• Dynamic Views are easier to build from Reports, particularly with large data sets
• Workflow paths branch based on decisions
• DV Details pane is where staff work (interact with workflows)
• DV is required to compartmentalize sensitive data

Example where improved logic is required:

• Options in the Status field drop down each require different info and steps depending on the review cycle.
  • We can't mark all fields as required due to varying needs across Status options.
  • We can't leave all fields as optional as critical information may be omitted.

Issues:

1. In the current system, we must work, save, exit, then re-open to check for missing fields. This wastes time and causes issues like filtering out rows unintentionally (DV or parent Report).
2. DV ignores required fields that rely on logic to make them required or visible, causing confusion and rework when missing data isn't flagged until later.
3. No other tool I know of requires reloading work to check if all steps are completed.