-
[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([%…
-
Admin Access to Everything?
Is there a way that a Smartsheet Administrator would be able to gain access to all sheets/workspaces, even if not specifically shared to the admin? I am asking in terms of access controls, so we can put a control in place where the admin ensures no PI or Confidential informaiton is being added. Thanks!
