-
Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…
-
number of days between one state and another (not including weekends)
I need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone help me with this? date of creation| Name | Status | DAYS WITH THAT STATUS 03/03/2018 | cristian | busy | 1 02/27/2018 |…
-
Reporting and dashboard help
I have a smartsheet containing work experience for every person in our company. The rows go something like this... * Steve Smith | Project Manager | Company A | 2.5 years | etc... * Steve Smith | Project Manager | Company B | 1.5 years | etc... * Steve Smith | Project Coordinator | Company B | 5 years | etc... * Karen…
-
Troubles when Posting
I keep on getting this message when I try to post a question about some formulas: "Your submission has triggered the spam filter and will not be accepted. If you feel this is in error, please report that you are blocked." Yet this post seems to work fine. Any ideas on what the problem could be?
-
Adding task line in one sheet and displaying in/moving to another
I have individual sheets created for 4 people (one being mine) where we have lines for all our tasks. I use a Report to consolidate all 4 sheets. However, when I have a new task I want to assign, I prefer not to have to access each of their sheets to add a line. I'd like to add the task line on my sheet and assign the Task…
-
Issue with comments in Community
Hi Guys, This is an issue not with SmartSheet but with this forum. I have tried Chrome, Opera, Firefox and Edge on Windows and Chrome and Firefox on Linux and get exactly the same behaviour: The issue affects just content in the Comments section of posts in the Community. When I am not logged in to the Community and open…
-
Changing outlines of Gantt chart bars
Hello, I would like to change the colors of the outlines/lines around the bars for sub-activities in the Gantt chart. I was able to change the fill color but the outlines are still light blue. Is there a way to change the color of the outlines? Thank you very much! Kind regards Ulrich
-
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.
-
one time change cell
Hi, There I would like to know if It is possible to freeze a column one's validation is given to make sure no more modification can be done. Thank you,
-
Setting intermittent dates for a single task
I am just getting started with Smartsheets. So far, I am really liking the ease of set up and functionality. One issue I am struggling with is how to set up intermittent dates for a single task. For example, I have a single task where I want to set a date for every other Friday to meet with the client. I don't want to have…
