Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Can you hide a "Lane" when publishing a sheet in Card View?
I am publishing a sheet in card view - but i have two lanes that have a gian amount of tasks in them - theses are the 'Not Started' itemes. I dont want to show those lanes when publishing. Possible?
Times in calendar view
Hi there, I've read some previous threads from 2015 about this, but wondering if there's been any further progress - we manage multiple events a day and with the calendar view not showing specific times it's difficult to utilise it to its full capacity, particularly as I am trying to also sync it to the larger calendar on…
ODBC connector to Excel - how to share resulting workbook
Dear all: Succesfully created an Excel-based workbook where data are sourced from Smartsheet, by installing the SMartsheet ODBC data connector on a Win10 machine; created and configured a DSN; and configured said DSN with my Smartsheet user credentials and API token from my smartsheet account. Let's call me user A. The…
how to sort filtered data?
hi, i can sort and then filter but not filter and then sort, how come SS offers one and not the other please? Btw...I love the new filter options and being able to save filters is genius. Thanks SS.
Recurrent Reminder for anniversaries and Birthdays - old dates
Hi there, I set up a spreadsheet with all our employees' details. Now I need to set up recurrent reminders for Date of Births and Anniversaries, but obviously, being old dates they are not considered. Is there any way where this can be done? Thanks
How to remove weekends- calendar view
Is there a way to remove weekends in the calendar view?
Reporting - Hierarchy functionality
How do you create indents in the Reporting function that was done in the Project Plan? At the moment, when I generate a report it lists a series of tasks but does not create the hierarchy that is done in the Project Plan
Conditional Operations on Read Only Fields when Record is Modified
Scenario Two Fields Responsible Date Closed (read only) Requirements 1) When the record is updated, if Responsible equals "Closed", automatically populate Date Closed with TODAY() 2) When the record is updated, if Responsible does not equal "Closed", automatically populate Date Closed with blank What tools/methods can be…
How to convert dates to Long Form Date format?
I understand that date formatting is normally set in "Personal Settings" but in order for the SmartSheet Merge to work for a problem I'm trying to solve, I need to convert the date to the long form (February 11th, 2016 instead of 11/02/16. Is there a script or IF statement that I could use to make the change? Thanks, SRC
Timer for smartsheet tasks, optimally with comments
Hi, I was wondering if there is a way to easily log time spent on a task and add, optimally, to add comments when finished. Here is what I envision: There is a little clock or stopwatch icon for every task row. I click the icon and a timer starts for that task, maybe turning green to indicate I have started that task. When…