Best Of
Re: Conditional formatting for Reports
This idea seems to have been listed as on the roadmap for quite some time now - I'm also really interested to see this implemented.
meagans
Re: Conditional formatting for Reports
I love that this is on the roadmap!
While we're in active enhancement to Conditional Formatting, can we add the ability to conditional format to an entire sheet?
(I.E. "If this symbol, or word, or whatever is anywhere on my sheet, apply this formatting)
Because applying multi level conditional formatting to a 400 column max sheet is an incredibly daunting task. And leaves a massive margin of error.
Paula Grahame
Metric Sheet - Not updating with Automation Date
Hello everyone,
For the past year or two, I've been using automation "Record Date" set to daily as a trigger for the cross sheet references on this metric sheet to update. As of recently, it stopped updating the references despite the automation running and updating the date.
Was there a change that broke this?
Thank you.
SteyJ
Generate Documents from Row Report
When using Generate Documents from a Row Report designed to contain the fields that are mapped to the fillable PDF. The only option is to download the form, attach to row has a the null icon for a hover bubble. In our use case we use a row report to ensure that all fields to be included in the document are complete then we generate the document. My team are admins to the report and I am the owner and none of us are able to attach to row. I do not find any reference to this limitation from the support documentation. Can you please assist?
Jay Nutter
Re: User Subscription Model - NEED a static VIEWER ONLY option (interns, temps etc.)
I have definitely seen users downgraded from Provisional to Viewer and then if they edit, they become Provisional again. Meaning if I make them a Viewer and anyone shares a sheet with them as an Editor, that winsβ¦and as soon as they actually edit, they become a provisional user again. If they permanently stayed a viewer only after downgraded once, eventually everyone except the company PMs will have been downgraded once the project they contribute to is over.
I really appreciate everyone's feedback as we all try to learn this new User Subscription Model!
This goes back to the topic of the IT Admin over Smartsheet no longer has control over the budget without a lot of manual work. And in this business environment, that won't work well if this product becomes highly manual (either manual to maintain or manual because you can't have many users any more).
JGPM
Add FORECAST Function/Formula
A Forecast function/formula would be incredibly helpful by increasing the value of the available data, and also its ability to be dynamic. My team has been looking for a solution to the lack of a Smartsheet forecast tool for years. This is the roadblock keeping us from exclusively using this program for all of our needs.
Zach Love
Add Quick Filters on Column Headers (like Excel)
It would be very helpful if Smartsheet allowed quick filters directly on column headers, similar to Excel.
Right now, creating a filter requires multiple steps and saving it, which takes extra time for simple tasks. Having the ability to quickly filter a column by value, number, or condition (directly from the header dropdown) would make Smartsheet much faster and more user-friendly, especially for large sheets.
This feature would improve efficiency for all users and reduce the need to export data to Excel just for quick filtering.
Copy-Paste
Please add the functionality to copy and paste rows (from reports, sheets, or anywhere in Smartsheet) with their respective formatting, formulas, and validations, just like in Excel.
Right now, Smartsheet only pastes the raw values, which forces us to export to Excel to preserve formats and then re-import. Having full copy-paste with formatting would save a lot of time and make Smartsheet much more efficient. π