Best Of
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
Ability to update the source item (sheet/report) in Smartsheet Calendar App
To ensure the published link isn't broken.
Jacob Schwanz
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
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
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
Re: Thin Blue Line Cell Highlight Hard to Find
Has this concern ever been addressed or corrected?
Mary L Smith
Re: Table view initial release is now generally available for all customers!
Is there a video tutorial of the features?
Heather White
Re: Table view initial release is now generally available for all customers!
How can I get the images to show in a column?
MPath
Show Sheet Owners whether the people they are sharing to are members, provisional members, or viewer
With the new changes to the licensing model for Smartsheet, there will be an impact from sheet admins/owners sharing their sheets to users who are not licensed. Unfortunately, the sheet owners have no way of knowing which of the collaborators are already licensed.
I propose a feature where licensed users can see the license status of individuals when sharing their sheets. This would help users identify who already has a license and avoid unnecessary provisional licensing. When users go to share a sheet, there should be some kind of indicator (a check mark or something) next to the names/icons of those who have a license, similar to the way that when you are sharing a sheet, you can tell whether the user has an account based on their icon appearing.
This would allow sheet owners/admins to self serve and take responsibility for the license impact of their usage.
Robin Poppsinger