Best Of

Hi! Date math in Smartsheet requires fairly complex formulas for anything besides adding days. Can we add something like EDATE from Excel? This allows you to add a start date and a number of months to generate a new date.

Hey All,

I submitted this product enhancement request through a feedback request a while back but I think this idea has a lot of merit and would really benefit the community as a whole. If you are like me, I'm sure you are all using and loving the AI feature!

One thing that has been cumbersome about it has been that in order to use the summarization feature you must apply the formula to each row individually. For example, I have a Request Description and a Request Type column that provides the details of the request and I use the AI tool to populate another column titled Request Title. In the column description of Request Title I have, "AI: Generate a generalized version of the [Request Description] and the [Request Type] cell into a short title the explains the Request description as a whole. The title will ideally be 4-8 words." which I paste into the AI feature to provide a title for that row. Usually I let 10 or so request come in so I can do it all at once but it can take a good amount of time.

How cool would it be if you could make a column formula that says something like:

=AITAS([Request Description]@row, "Generate a generalized version of the [Request Description] and the [Request Type] cell into a short title the explains the Request description as a whole. The title will ideally be 4-8 words.", [Request Type]@row)

Allow me to explain in terms we are probably more familiar with.

AITAS = AI Text and Summaries

Example:

=AITAS(Value_to_assess, Prompt_to_AI, [Additional_Value_to_Assess1], [Additional_Value_to_Assess2, …])

Summary:

Returns the AI's Summary after assessing the values at the cell(s)

Arguments:

Value_to_assess: The value, typically a cell or rang of cells, referenced in the Prompt_to_AI.

Prompt_to_AI: A prompt defining the task you are asking the AI to do.

Additional_Value_to_Assess2, … [optional]: Additional values or ranges to refer to in the Prompt_to_AI.

First time write out one of these formula statements so be kind haha!

Let me know what you people think! 😁

I have created a dashboard that I would like to export to PDF to share to people that do not necessarily have Smartsheet and more importantly don't want to open links/attachments to get "quick glance" data.

When I print as PDF I loose a lot of formatting and can't centre the data across the page. without customising margins.

Being able to export Dashboards would be a brilliant tool to have with multiple out put types, like slide, document and email. Adjusting standard sizing and formatting points to suite each output types.

I would like the ability to add color to column headers or to rotate the text 90 degrees to minimize how long a sheet gets with multiple columns which would help visually on a dashboard.

Visual from my dashboard currently where the column header can only display in grey:

Yes, please support moving the value inside the bar on the chart. For a "Stacked Column" chart, the label is confusing in it's location "on top". I have to turn off the label or people get confused, and when needed I end up rebuilding it in Excel instead.

Enable Cells with Checkbox Styles as Flags or Stars to be changed similarly to how cells with "Checkbox" styles are able to.

It would be helpful if for update requests you could set a due date and for a reminder email to go out at a designated interval prior to that due date if the update has not been submitted. It would also be beneficial to allow for the manual sending of a reminder off of that update request record as well.

Would love to see a feature to remove duplicate rows in a sheet. I have an automated rule setup to move rows into a sheet every day and some of the rows are duplicates. I would like to automate the process of removing those duplicate rows.