-
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…
-
Add hyperlink to related sheet from the report
I'm creating a "summary schedule" report from the project schedule and would like to include a hyperlink to the full project schedule within the report for quick access. Any tips to offer on that?
-
Automatically add emails into smartsheet
Is it possible for an email to automatically be added into a smartsheet? Just like a form entry gets added, can someone send an email to a particular email address that is automatically added to a smartsheet? I saw an old post about this from a few years ago but want to know if this is something that can be done now. It…
-
access across multiple sheets
Hello, I have several smartsheets that needs to be reformatted the same way. In addition, I need to create access to forms I have created using Microsoft Office. Is there a way to create access and modify across the board without having to replicate changes to multiple sheets? This is especially important for my forms?
-
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…
-
Formatting doesn't work for copied cells
Good afternoon. Can anyone help me with the following issue? I have a workplan on a sheet, where I coloured lines, separating sections of the plan, in a grey. Afterwards I copied a formula to all of the cells in a specific column, while the whole column became white (i.e. it changed grey into white in some of the lines).…
-
Requesting scheduling for events that show up in calendar view
I'm using Smartsheet to request things through different processes in our organization, but one request process that is giving me headaches is requesting after hours air conditioning. We use building automation to control when air conditioning runs, and people have to request A/C if they are using a facility when the A/C…
-
Add up all PAST DUE Items
I would like to add up all the action items on my Action Item log that are Past Due so I can show this on my project dashboard. How do I construct the COUNTIF statement to achieve this? Thank you from the newbie!
-
Columns sorting in a New Report
Hi, I'm to create a report from a sheet which has many colums. In the report builder, it seems I have to select them one by one, and the column list is sorted alphabetically, so if I am to present them in the same order than the sheet, I have to find them in the list one by one. Please, is there a way to create all this…
