Best Of

Dynamic View Button

It would be nice to have the option of sending a custom email for Dynamic Views, that contains a clickable button to their dynamic view instead of them having to click or copy a link into their browser.

We share dynamic views via automated emails to stakeholders all the time. Currently the dynamic view links exhibit inconsistent behavior when it comes to hyperlinks.

Sree G

3 ·

Re: Formula for date range after two different dates

Hi @mreynolds66

So I have my date format set up for UK format DD/MM/YY but the formula that I would use is

=IFERROR(IF([Rehire_Date]@row <> "", DATE((YEAR([Rehire_Date]@row) + 3), MONTH([Rehire_Date]@row), DAY([Rehire_Date]@row)), DATE((YEAR([Hire_Date]@row) + 3), MONTH([Hire_Date]@row), DAY([Hire_Date]@row))), "")

Basically saying if the [Rehire_Date] column is anything other than a blank cell the date will equal DATE( Year, Month, Date) using the [Rehire_Date] column as your date starting point, and then else DATE(Year, Month, Date) again but this time using the [Hire_Date] as your date starting point.

The only reason the IFFERROR( ,"") is in there is just incase you have row entries without any of these dates in it. If you are always going to have those rows then you can change the formula to

=IF([Rehire_Date]@row <> "", DATE((YEAR([Rehire_Date]@row) + 3), MONTH([Rehire_Date]@row), DAY([Rehire_Date]@row)), DATE((YEAR([Hire_Date]@row) + 3), MONTH([Hire_Date]@row), DAY([Hire_Date]@row)))

Please double check if the date format changes the DATE(Year, Month, Date) function format

Gillian C

1 ·

Ability to update the source item (sheet/report) in Smartsheet Calendar App

To ensure the published link isn't broken.

Jacob Schwanz

2 ·

Data Shuttle Date Formats - current crazy conversion

Need to be able to specify date formats in data shuttle OR for it to adhere to the formats in the uploading CSV file and/or smartsheet.

For example: I have a CSV file to upload via data shuttle with date dd/mm/yyy. The smartsheet has the regional date setting of dd/mm/yyy BUT data shuttle takes a "best guess" and is converting my 01/05/2025 to 05/01/2025 which is total madness.

I have checked with support and YES this is what it does.

Please everyone vote to have the date formats fixed in data shuttle

SueinSpain

3 ·

Re: Provide users with the ability to Print a Grouped Report

When will this issue be addressed? It's a major stumbling block to not be able to export a pdf of a report or dashboard as you see it on screen. Conditional formatting and grouping is lost in the translation.

SueC7420

2 ·

Is there a way to change the highlighting color when using the FIND functionality?

Currently when we use "FIND" on a page, it highlights the cell in the found results in white? They can be a little hard to find on a sheet. Is there a way to change the color it uses to highlight the cell? Or can it highlight the word or change the text color on that word?

Thanks!

Kathie Ryan

1 ·