-
Creating a Link in Dashboard from local drive
I have previously been able to create a link to a local drive document on a dashboard but now don't seem to have the choice. Can someone point me in the right direction please? I have the options of Google Drive; OneDrive; Box; Dropbox; Evernote; Egnyte Thanks
-
COUNTIFS to count when a cell contains any version of a word I want to count
How do I indicate that I would like to count any time the cell has "DESIGN" in it whether the cell says exactly "DESIGN" or "re-DESIGN"?
-
Automatically Sort Data
Hi, Our team works with a spreadsheet which currently is updated quite often / simultaneously by several users. We have been facing difficulties whenever new information is added, since sorting is not properly adjusted until we manually select sorting, refresh and save the data. Is there a way to automatically sort…
-
How to print without Conditional Formatting?
I have a sheet with a lot of conditional formatting that must be printed in the gantt view without any of the formatting. So each week I have to disable all the rules, print, and then enable them again. It's tedious. There must be a better way. Any thoughts on how I can generate a gantt in a PDF without the rules and…
-
How export to Microsoft Project without dates missmatch?
When export my Project to Microsoft Project, start and due dates doesnt Match with smartsheet dates. Some one know that do I need yo do to hace the same information?
-
Need a Column Property type that is "clock" or "time of day"
As an event management company, we have on-site event schedules that require a "start" and "end" time column. Those columns need to reflect the time of day and currently we have to create a whole drop down list of 24 hours to choose from for those columns. Am I missing it if it already exists? Or, if not, it would be great…
-
Label Parent to Sub Tasks in Reports & Reminders
It would be helpful if Reports, Reminders and the current Outlook Beta displayed parent task descriptions when information is displayed for sub tasks. In our organization, many sub tasks could have similar descriptions in several phases of our projects. It would be beneifical to see the parent or outdented rows description…
-
Wanting to count dates within a column
Hello, I'm trying to create a monthly report from quarterly data. I want a formula that will count how many projects went live in a given month from a column of dates. In the screen shot, I want to put a formula in the blue cell that tallies the Actual Live Date column. Thoughts? Thanks! Shannon
-
"The source data for this chart has changed" - Charts with Zero Values
Hello. I have noticed that charts within a dashboard do not display and throw up a message: "The source data for this chart has changed" when they are pointed at sheets or reports where the value is zero / 0. This is problematic for me since I have created a dashboard for a template set of sheets and reports, and…
-
Access to a detailed task description
On the same basis as the tasks comments, I think it would be great to be able to edit a detailed description of each tasks. A detailed description is really important if several people can create tasks. It provide a clearer insight of the perimeters of the tasks, may enumerate a number of subtasks, providers, hyperlinks,…