-
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…
-
Method to update field automatically (based on other field updates)
I was looking to see if there was a way to make an update to a field based on the status of other fields in the sheet. In my example I have a review process that sends multiple emails at once for review and approval. The reviewers each have a field that the indicate approved or rejected in. Once all of them have approved I…
-
Quote Tracker Project Template
Looking for a project template for tracking quotes from multiple suppliers for a long list of parts.
-
Rows
Has anyone had problems with rows moving radomly? Any ideas on how to prevent this?
-
Custom Views
Hi everybody, this is probably not a new one, but I've not been able to immediately identify the right thread - therefore let's try again: We've started a new sheet with some intense collaboration, and everybody has his preferred view in the meaning of what to collapse and what to extend (preferences as well change over…
-
HELP! RYB Color Change Based on Dates
Hello everyone, I am currently using this: =IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 >= Completion4, "Green", IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 < Completion4, "Red")))) Which is working but I try to add this: IF(ISBLANK(Completion3), IF(NOT(ISBLANK(Supervisor4)), "Yellow" And it doesn't work, I'm…