-
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…
-
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…
-
Searching in Smartsheets - doesn't show ALL possible results
We're having trouble smartsheets in our office because when we try searching for a particular item, it doesn't show all possible results. Is there a setting that we should change to be able to search and view all possible results? As you can see on screenshot 1 the results do not show when I search for CL035 even though…