-
Workbook template set for new project
Hi there, My first post to this forum and somewhat new user to Smartsheet. Can anyone advise if below is possible and if yes, how to do this or point me to help on this topic. Thanks a million! *** I want to create a template set for a suite of document that I need to create for every project. What I do today is use an…
-
All videos simple - don't show realty use of training needs
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…
-
Page Layout with a table and summaries
Smartsheet often shows a nice calculation at the top of a sheet. Say a list of dealers. The first five lines of the sheet have a nice summary box with the number of dealer in each state calculated or soemthing like that. Now the sheet column headers are really matching the data table not the summary table. So name,…
-
How to start building project roll-up with 110 dropdown names to pick also
Where to start, project roll-up, don't want a done of linked cells if can avoid it. Need it simple for user interface. Today using Excel just type it in, pick the color for the cell. The color means something based on a key. There is high-level corrdination of the overall program, then high-level for a project, then…
-
Creating a cell link to a different sheet with different working days
Dear community, I have created a sheet for Data Center migration planning. By definition these activities are planned during normal working days (Mon-Fri) but the migrations happen during weekends, as it requires to stop servers and so that's the lowest impact to services. This sheet has defined all days as working days to…
-
Share a Smartsheet folder to auto update added sheets/reports on Sights
Hi, Is there a way that I can share a folder with my team? I want to add the folder on Sights so that when new sheets or reports get added in that folder that it is already accessible in that sights folder without me have to go and add it manually everytime? Or any other suggestions on how new sheets/reports can be…
-
Automatic email notification link when comments change or are added
The automatic email notifications based on the comments changing is nice, but the link in the automatic email notification does not take the user to the specific comment that was added or even the row it was added. It requires the user to go back to the email to look and see what row the comment was added to. This is…
-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
Keeping parent Task during filter search
I have been using the Parent Task as a header for child task below. The child task has an owner, the header does not. I'm in construction so for example the Contract header has child items such as site visit, develop scope etc. My owners don't want to see all the items that they don't own and I have a filter for each owner…
-
Publish Calendar Format - Hyperlinks Lost
Hello, I searched but didn't see an answer to this issue: I maintain a calendar, based off a SmartSheet template, whichI publish to our intranet. In the description field, I would like to include hyperlinks. In grid view, the hyperlinks are active and functional. When I change to calendar view, both for myself or looking…
