-
Effectively using Link Cells
Hi guys, I'm eager to understand the easiest approach for using the Link Cell functionality with templates. I am building a 'Project Master Listing' document that will have cell links to multiple 'Individual Project' documents. When each new 'Individual Project' is created i am assuming i need to manually associate the…
-
SUMIF Circular Reference
I have a time/hours sheet to keep track of customers that have varying statuses. The statuses include in progress, complete, and cancelled. I currently have the sheet being sorted based on the status so that It has a title row showing the total numbers for each status below it. As a status changes from in progress to…
-
URL for Folder / Folder URL
After seaching I did not find reference to this topic... So, in support of a highly organized system (using workspaces w/ folders), well-documented work processes and efficient execution of work tasks, it would be nice to link directly to a Smartsheet Folder using a URL. Is it possible to link directly to a folder located…
-
Default dates on web form
Hello All, I use smart sheet as project list and a web form as a work request. Our policy is that all request need to be submitted 4 weeks prior to their due date. Is there a way to have the duedate field on my webform defaut 4 weeks out from the date the form is accessed?
-
Set up notification for a complete workspace
Hi, I'm doing project management amongst multiple projects (1 project = 1 sheet) that are all in one workspace. Is there a possibility to set up a notification for the complete workspace? It's quite anoying to set up a notification to each single sheet. As I read in another discussion it's not possible to use notification…
-
Full Screen Published Sheets
Hello, Would be useful for the sheets to be have the ability to function in full screen mode only as default, as a better view when embedded in another site. Is this already possible, if not could this be adopted as a function? Cheers,
-
Sharing Filtered Gantt Charts
I want to share a filtered view of a smartsheet (gantt chart enabled) that shows: * dependencies and parent/child relationships that the user can close and open to help them focus on what they want. If I make a report out of it, I loose the parent/child functionality and the dependencies aren't displayed. I'm resorting to…
-
Best practices; optimum template design for pulling/pushing distilled info from a sheet
Typical project management templates are not designed to easily get a distilled summary of important points. I am wondering if these is a template out there that would allow for easily pushing out or pulling from a sheet the following. If this info is in form of a symbol (Harvey Ball symbols for example) instead of numbers…
-
How to manage resource specific holiday calendar?
I use Smartsheet Project Management and Resources Management features regulalrly. It works great for standard work days and holiday calendar recorded for the project. However, there are situations when we need to assmble specific resources on other wise non-working days. Can you let me know how I could manage start date,…
-
New to smartsheet - Creating a document from several sheets of information
I am new to smartsheet and am self taught by using the youtube guides. I was hoping someone maybe able to guide me in the right direction. I am using smartsheet to create a log for new sample parts we need to test (product development testing). The log will contain a brief description, a photo, dates and also have links to…
