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.
Discussion List
Enhancement Request: Ability to use Rich Text or HTML format options for Comments
I would like to request the ability to use different format options in the comments window. We are currently able to add plain text comments but it would be nice at times to use a different format like Rich Text or HTML.
[Need Help] Non-License user can hide column but can't unhide?
Hi, I understand that only License user can hide or un-hide column in sheet they are admin. * Hide/unhide columns (also requires Sheet Owner or Admin access to the sheet) But we have some user (non-licensed but part of our Business) that are able to shrink a column in a sheet they are admin, but they are unable to unhide.…
Card view - collapse empty lanes automatically
Happy Monday! Is there any way to automatically collapse empty lanes in the card view? I like to show tasks in card view by owner, but we have a lot of possible owners which means scrolling to see all of the lanes when the task list is really concentrated on a few people at a time.
MS Teams & Smartsheet
Hi all, I've noticed that when using the MS Teams desktop app I'm asked to log into smartsheet each time I want to view the tab, I click on log in and nothing happens. This only occurs with the desktop app, the browser MS Teams app works fine. Anyone else had this issue (screen grab uploaded)
Date calculation - work days only
I found the formula for date calculation (today's date minus 2 days is =[First Test Date]5 - 2 in my case). But I want to make sure it's calculating only work or week days. Is that possible? Thanks, Jennifer
Primavera
Hello Everyone, Does Smartsheet can work or import primavera (enterprise project portfolio management software) ? Thanks for you help Olivier
Number and Fraction Format
We currently use a considerable number of sheets that need numbers to read as fractions. (Construction/Exhibit Industry for dimensions) Unfortunately, if you type out a number as a fraction it cannot be used in formula. Excel can translate easily between decimal and fractional display with cell formatting. Will there be a…
Rank formula?
Is there any equivalent for rank formula on Excel? I would like to create a ranking column based on value of another column example : Score | Rank 20 | 2 30 | 1 2 | 5 12 | 3 5 | 4 Thanks
Google Sheet Sync into Smartsheet
I realize Smartsheet allows sync for Google form; however, does it allow sync for Google sheet and vice versa?
Harvey balls based on range of values in % completion
I have a formula to use based on % completion of a project. I would like Harvey balls to show the status based on a range of values. It's not often that completion is exactly 25%, 50%, 75%, 100% This is my formula but how do I figure the ranges? =IF([% Complete]31 = 0, "Empty", IF([% Complete]31 < 0.25, "Quarter", IF([%…