-
No Bars
I have imported a checklist from excel, set it up as a Gantt (transposed columnar hierarchy,) put in predecessors, and durations. No bars appear on the chart. What's up with that?
-
REMOVING ALL HIERARCHY FROM SHEET
I'm using a sheet (Grid view) that I initially needed Parent and child rows on, but we have decided we would like a simpler format. I don't want to delete my sheet and start over because I need all the current data as I am still using it. BUT I want to go back thru the sheet and re-format it without the parent/child…
-
Special formula help
Hi, I'm hoping smartsheet community can help me with an automatic formula. We have a column called "Priority Deal" this is a symbol selection of the stars, where we rate a specific land opportunity (empty/one/two/three/four/five) I'd like to create a formula when a specific star is selected, the column "Deadline Date" is…
-
Checkbox tick then auto highlight certain columns?
Hi, We have a sheet called project milestones for managing the steps of LIVE manufacturing an installation projects. I'd like when our production manager selects a tick box on a specific row, that 4no columns within the row are automatically highlighted light green. The column "In production/ Approval Docs uploaded" Should…
-
Smarter Dropdown List Manager
Further to a considerable amount of Community requests for a way to Update Dropdown Lists in just one sheet, then have that list Automagically populate all the other Smartsheets that reference that list. Our Developers, using the Smartsheet API have created just that solution, in fact we have assumed that users will want…
-
Update Request History
Often I use the "Update Request" option to send the person assigned to the Task a reminder that a task may be due or question why the Task is behind schedule. I would like to be able to see a history of my requests so I do not repeat a request for the same task. It is generally the whole row that I ask for the update on…
-
Frustrating split of functions vs cost of license types
One very interesting thing for me is the curiosity I get from people around me when they see me using Smartsheet. The low threshold of knowledge to get into it and the "mimic" of spreadsheet (excel) view behind it makes it so much more attractive than MS Project for example. Often when I bring up MS Project as a possible…
-
Combine Kanban flow and Gannt
This might be a post in the category feature/best practice. I do find myself working quite often in a combination of Kanban and Gannt. The feature/best practice I would like to find is a way of handling some tasks as pure Kanban items in card view without soiling my beautiful Gannt view. As an example, if I do need to add…
-
Edit Predecessor Form will not appear in the Predecessor column
I am trying to add lag time to a project but when I hover the mouse in any cell in the Predecessors column nothing happens. The Edit Predecessors form does not appear. Please help, I've tried everything. "To make changes to the relationships between dependents and their predecessors, click Edit Predecessors (hover the…
-
Gmail add on for Smartsheet
The Gmail add on worked twice, but now doesn't place the email into the spreadsheet. It still finds the spreadsheet and the rows, but when you either select an existing row or attempt to add a row the cursor circles for a few seconds then stops and nothing further happens. Not sure where to go next. Any help would be…