-
Counting Check boxes when Checked
Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment. Another solution I'm thinking is possible is if…
-
Submitted Web Form - User Information
We are creating a web form to track business development possibilities. Other than adding a "Your Name" field to our web form, is there a way to see who submitted the form? On a current smartsheet where we are using a web form, I can right-click to view history, but it shows only "web form user". What we would like to see…
-
Date miss matching
Hi all, Ok so I reside and work for a company based in Bangladesh and we use this format for date ( Date / Month / Year ) so today will be 30/3/2019 I have two base sheet that feeds directly to a master sheet via direct cell linking which is used by the management to keep track of the latest updated. Now the base sheet the…
-
Working with Multiple Calendars, Vacation Days, and Weekend working days
In my project team, we have team members located in different parts of the globe. I need to link to the project non-US calendars and holidays aside from those of the US. Additionally, I need to enter the vacation days of all team members who has vacation plans or out days, and enter weekend working days when, say, a…
-
Resource Management
Creating a Resource Management plan and hitting two snags: (1) Not all sheets are being accessed for the Resource plan butResource mgmt. is turned on in all sheets (2) Not all resources are being pulled from the worksheets. Unsure what "Users in your user account" means - how do I ensure all resources are being pulled into…
-
Inconsistent format (mojibake) when exporting smartsheet Gantt to PDF
Hi, I created a Gantt with Smartsheet. Tasks names could be: - English characters only - Japanese characters only; and - a mixture of English and Japanese. When I exported the Gantt to PDF with: File => Export => Export to PDF I found that PDF generated sometimes show Mojibake (unreadable characters) when the task names…
-
Cannot format Milestones & Summary bars
I'm trying to use conditional formatting to change the color of milestones within the GANTT view. I've created a rule that looks for tasks with zero duration, and has the word Begin or Complete in it, and I'm able to locate the tasks, and format the text, but I'm not able to format the Summary Bars or Milestone indicators.…
-
Couldnt Find my Question Raised yesterday
Hello, I started a discussion yesterday but not sure where to find it now. I would like to see if anyone has posted answers to my question asked yesterday. Please Advice. Many Thanks Senthil
-
Split-screen auto populate?
Hello all! I have a smartsheet that is always open in our warehouse to let the guys know when an item needs to be shipped; the line is added by our procurement team. After the warehouse personnel complete a shipment, they mark the status of that line as complete and save. The line then gets crossed out but stays in the…
-
Expanding and Collapsing Hierarchy/Outline levels
Very much would like to have the ability to expand the hierarchy to a particluar level such as 1,2,3 ... ALL. For my applicaiton Level 1 is PROGRAM, Level 2 is PROJECT, Level 3 is milestone, etc. I need to see the entire sheet open to a particular level. Looking for something that exists in Excel as well as all "outline…
