-
Helpful Things I've Discovered About Smartsheet (Long)
I've been using Smartsheet for about 2.5 years now and gradually discovered how great it is for many tasks within a our small consulting company. While I originally started using Smartsheet for its project scheduling capabilities on large projects, I've ended up using it for much more. During that time I've discovered many…
-
ENHANCEMENT REQUEST: FROM YOUR CUSTOMER BASE
Open Topics Pending Product Reply on: * Fix the link to sheet bug not showing as a URL/link * Unable to unlink, delete and retype in text to fix * Ability to chance the background color in a Sight other what white/grey - fix to allow users to select a color or image upload * Ability to make widgets transparent and just…
-
Help with check boxes
Hello, I am trying to figure out the formula to get a check box to auto check when two other boxes are checked. In the image attached, I'd like to link the check Boxes in line with Person 1 and Person 2 to the check box in line with President Elect. How do I do that without linking all the other lines? Thanks
-
Outlook 365 Integration
I'm running Office 365 and within my desktop Outlook I have highlighted an email that I want to attach to a row in Smartsheets. I have the icon in Outlook "Add to Smartsheet". I open that icon within Outlook and I search for the Smartsheet. I navigate to the appropriate row and I can view all of the columns & data in that…
-
Display predecessor task NAME
We would like to write logic to display all predecessor task NAMES in a new column. So we want the predecessor task ID to be in its usual column, and we want a NEW column that shows the NAMES of the predecessor tasks. Anyone done anything like that? Thanks Robin
-
Have Sheets feed child rows automatically into a Master Sheet?
Forgive me if this topic has been covered before, I've done the best I can searching. So my employer wants to have our projects be listed in a sheet, each department in a different sheet and to have that information feed into a master sheet (or a couple master sheets actually). I know you can cell link one row at a time,…
-
Link to a cell in the comments
Hi, Is it possible to paste a cell link in a comment of another sheet? I have a sheet in which certain rows refer back to other rows in other sheets. I want to be able to paste that cell link in the comments for quick access. Y
-
Auto showing completion based on child checkboxes
Hello. I've setup a task list with check boxes. After indenting portions of it to show child tasks, is there a way to have the parent row automatically highlight, or show a value, when all the child tasks are complete? I would then link the parent row back to a master sheet to show a completion on a single line in the…
-
Mid and Value formula
-
Dependent Drop Down Lists
I need to create dependent drop down lists. We are dealing with multiple categories that then have many subcategories each. In Excel I can create a dependent drop down where if the value of cell B3 is Accessories, then the only choices I have in cell C3 are the accessories subcats. Obviously one can manually choose the…
