-
Generic "Forms" embedded in a sheet?
HI, I am pretty new to Smartsheet so, please forgive me if the solution to this question is obvious to most. :) Our company is developing some project management sheets to help us in our transition to paperless. We have put together a template that we feel pretty satisfied with to get going and as we start each project, we…
-
Date Created System Column not updating if NOT using webform
I am modifying the "Help Desk Ticket Tracker & Form" template. I don't want to double-enter the date, so I deleted the 'date' column and am using the 'Created (date)' system-generated column. When I use the webform, it will fill in the date created. But if I add a line directly in the smartsheet, it leaves the Created date…
-
Project Resource View
Hi: I'm looking for a way to where the Project Resource View will list actual Task Names against each resource in my project sheet instead of the smartsheet file name against each person. . Is there a way the Project Resource View can be tailored and utilised as a resource management tool?
-
Sights access
Hi there, Does anyone know if Sights can be shared with people who do not have a Business or Enterprise account? Thanks, Paul
-
Duplicating projects with cell linking
We set up our each project with individual department sheets that link to other department sheets. The issue we have is each new project, we replicate the prior project, but have to redo all cell links. What I'd like to be able to do is set up a template project that can be in total so that all the new sheets link to each…
-
Parent Row Symbols based on highest priority?
It is possible to create a formula that will change the symbol to represent the HIGHEST level out of the 4 rows? IF the (HIGHEST) Risk Level for rows 1-4 is "x" THEN action for symbol column is "low" = blue symbol is "medium" = green symbol is "high" = yellow symbol is "extreme" = red symbol I currently have a formula to…
-
Emailing reports, except for when blank
I have a report pulling data from several sheets inside my workspace. Essentially it emails the report as an attachment every morning at 9am to my team and lists out open project needs. The question is there are some days when the report is blank (ie. no open project needs). Is it possible to: * not send an email if report…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
Formula HELP!
Need Help! I need a few of formulas. (1) Formula to automatically populate a due date (2 weeks after start date). (2) Formula to calculate duration between two date columns. (3) Total parent rows (projects) and total based on parent color. I'm at the end of my wits! Thanks everyone!
-
Help with Column Edit Permissions
Hi All, When I share a sheet with my associate (or visa versa), the person who did not create the sheet is not able to edit the column properties. They are 'grayed' out. I checked and it looks like we both have the same permissions, so Im not sure why that happens. Any advice would be appreciated! Thanks, Robyn