-
Published card view not showing filters?
I'm using card view as an internal support ticket queue that the company can view. There are teams within the company and I want them to be able to quickly view their specific tickets without the other team tickets showing. Filters seem like the best solutions (there are other solutions but not as pretty) but when I…
-
OFFSET FUNCTION
Hi SC, Does Smartsheet have an equivalent of the EXCEL OFFSET FUNCTION ? Thanks
-
Link to cells in a different sheet
Hi SC, I need to link cells across two different sheets and I am looking for a way to avoid having to create the link one by one. The cells to be linked are located in adjacent columns so ideally, I would just need to create the first link for the first column and then drag the formula through all the columns. I tried it,…
-
Restrict to List values only
I noticed when I create a drop down list for contacts and select "Restrict to list values only" it works great in the main sheet, but when I view the same column in a report it is not restricted to list values only. All the contacts shown on that sheet also shows in that list. Am I doing something wrong? or is there a…
-
Is there a Japanese or Japanese company here?
Hello there, This is Kikuchi, working at a Japanese company in Tokyo, Japan. We are going to start smartsheet in our company and wondering if there are any Japanese users here? so that we can exchange the questions or experiences. Please let me know if you are a Japanese!! Thank you very much for your attention. Best…
-
Comments input area is 'hidden'
When I open the comments dialog, the area to input text is hidden. It has been this way for a few days now. What can I do to fix this?
-
Enhancement Request: Sights Auto-Refresh
We have created a departmental dashboard and we're displaying it on a 40" LCD. It looks completely awesome and we are now the envy of all other departments... BUT, the screen doesn't automatically refresh. We created a script that automatically refreshes the screen every 5 minutes and that is working to update the data,…
-
Messaging collaborators
With so many collaborators working at any given time on the same sheet (you can see when someone enters or leaves a sheet), has any thought been given - is it even possible - to having an IM-type feature whereby you could message others in the sheet at the same time? We already have IM software internally which we use…
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
Setting Conditional Formatting/Formulae(?) for Red Yellow Green balls based on % Completed
Hello, I am trying to have the Red, Yellow, and Green status balls automatically change/update based on the percent completion of each row task. When I click on the conditional formatting button in navigation pane and make new rule of, "If % Complete is between range of 1% and 99%, then change the status column to Yellow"…
