-
Autonumber refresh for new year
I use a formatted autonumber column to record a new Reference Number for each new entry in a Smartsheet. The format I use is CR{YY}.000 where 000 started from 001 for the year 2016. I want to continue this format into 2017, but I want the 000 to restart from 001. Any thoughts ? My list of rows should end up like : CR16.001…
-
Month Count/Summary as Integer
I have looked for examples but can not find - apologies for basic formula question. From a date field i would like a formula that will take the month and total/count by month: Eg: Month 1 - Total 15 Month 2 - Total 9 to Month 12 - Total 0 Can anyone help? many thanks Chris
-
Filtering Calendar View
Is there a way to filter the calendar view to show more information (from other columns) rather than just the primary column information?
-
gant bar color
Hello, I am desperately looking how I can change the color of a gantt bar. Right clicking on it .. only shows me "edit" option .. but not "color" option. conditional formating : If I select to apply a color to the whole line .. then it allows me to indicate also the gantt bar color .. . If I select eg red .. it doesn't…
-
Search functionality - returning matches on subset of a search string. Also, wild card usage is non
It appears that Search is not working correctly. Please review the Search functionality and also the use of wild cards. 1) The search results will include matches to the full search string but also to any 3+ characters within that string. For example: A search for beets would return a results list that would include beets…
-
Can Smartsheet to perform a Mod Function?
I am a network engineer and I am importing an excel spreadsheet into smartsheet. My spreadsheet is an address calculator for quiclky identifying IP addressing for my organization. My spread sheet has the use of the "MOD" function and is contigent upon using this function. I am aware that the "MOD" function provides the…
-
Salesforce & Smartsheet integration - executing workflows via API
Hello All I'm now investigating Smartsheet & Salesforce connector. I configured "one-direction-only" data synchronization from Salesforce to Smartsheet. It works pretty well - once you hit "Run" button on the https://connectors.smartsheet.com/c/salesforce page. Now I wonder if it could be possible to start synchronization…
-
Possible to close Comments window using a keyboard shortcut?
Does anyone know it the Comments window can be closed using a keyboard shortcut or are we required to click on the 'X' icon in the top-right corner?
-
Symbols not appearing in reports
When generating a report, my status symbols are displaying as text not as a symbol but are a symbol in my project plan. This has only recently occured.
-
Export from Tableau into SmartSheet
Hi all, I am aware of an ODBC connection that allows us to display SmartSheet data in Tableau dashboards. Is anyone aware of a way to export data from Tableau automatically into SmartSheet? (i.e. - the reverse flow of information to the existing SmartSheet-Tableau interface). Perhaps someone else in GE has developed…