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.
Archived 2016 Posts
Archives for September 2016
Discussion List
Calculating a day from a date
I've got a column (called "Dates") formatted as dates. I would like the adjacent column to show the day of the week that date falls on. Using the formula =text((Date1), "dddd") brings back an #unparseable error in the cell. I've tried using brackets instead of parenthesis but it hasn't worked. I must be messing up the…
The row is not street when I insert Korean language.
Hello. I have some problem with smartsheet. The problem is When I insert Korean language, the row is not street line, and the focus is not position in correct place too. How can I resolve the problem? Thanks a lot.
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…
Smart Sheet labs - map
Hello I'm creating a map in Labs and 13 addresses will not populate. All have been verified as correct. Any ideas why this might happen?
portfolio roll up - Waterfall and Agile templates
Hi, I use waterfall and agile methodology as per project requirement. I am creating a portfolio master roll up report for executives. When I pull all the projects, it pulls only waterfall templates ( yellow row). How do I make sure it pulls agile projects too( organe row)?
eAcademy Quiz Question
Has anyone failed a quiz in eAcademy and tried to retake the quiz but the system would not allow you to complete the module? I failed the Apps & Integration quiz. I've completed everything else required to unlock the Wrapup and Certification Test but the system will not allow me. I've emailed Support and they are having…
CountIfs and Blanks, not blanks
Hi Guys I have two columns of data that I want to summarise with a count into a specific cell where the follpowing conditions are true: The first column is NOT blank AND the second column IS Blank. Not sure if CountIf's is right for this. Any help would be appreciated! All the best Barry
Conditional Formatting
I was wondering if there is a way to apply conditional formatting on a cell based on the outcome of another cell. For instance, I have a % Complete Calculated column and a % Complete Actual column. Is there a way to change a cell in the % Complete Actual column yellow if it is less than the % Complete Calculated?
Zooming in on Smartsheet
Hi In most excel applications, you can press Ctrl, and scroll to zoom in and out of a worksheet. Is this possible to do on smartsheet? Thank you Harry
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.