-
Need Some Help Nesting IF Statements
Hi everyone, I am trying to use End Date, Duration, and % Complete to calculate the correct color ball in the status column and I am having trouble combining the statements I believe I need (might be wrong with my basic statements also). Here is my thinking: Red – if you are at OR past the end date AND not 100% complete…
-
Specifying task durations in months
This may sound like a foolish questions..... I specify my task durations in days. Can I specify some of them in months? The reason I ask is that I noticed that when I enter a duration as 6 it displays "6d" for 6 days. We have a number of tasks that have contractual commitment in 3 months. Therefore, the need to be able to…
-
Percent Complete by Cell Color
Is there a formula to determine percent complete of a task based on the cell color? Cells are filled with dates of various steps in a project and once those are completed, the cell is highlighted. I'd like to have the percent complete column update automatically when the cell color is changed. Help, please!
-
URL direct into Card View....or make card view the primary view?
I have a lot of team members who struggle with new tools. The card view is VERY easy for my team to navigate and quickly shift items around. The problem is that the link I provide for them to access the Smartsheet always defaults to the standard spreadsheet view. I get calls of confusion because they forget how to toggle…
-
Including only the most recent comment.
Hi there, Within the "Print Setup" for .pdf reports, under "Options", "Include comments" checkbox....when selecting this checkbox it prints out the full set of comments which is fantastic but can make the report quite lengthy, especially over time. However is there a way, or is it possible in future upgrades to select an…
-
Report selections not working correctly
Hi all, really scratching my head here... ...I'm a fairly proficient user, but am getting the following problem. If anyone has any ideas I'd really appreciate it. I have a set of individual projects with extensive links into a master log sheet. Off this log sheet I have report that select for who the tasks or projects are…
-
Row Sharing- visibility, edit, comment on Attachments
We have implemented a new process for our Development team and Clients and have run into the following issues: - Is it possible to share multiple rows and 'zip' all the attachments in the rows? I do not want to allow access to the full sheet or the Dropbox for the files. - For shared rows, we need them to be able to…
-
Creating a Project Plan Template
Hi - Has anyone created a Project Plan Template that can then be duplicated to create a new baseline project? If so, can you share how you duplicated the template? as well as any other suggestions based on what has worked well for you? Since a lot of our projects are very similar, it would help us to not have to reinvent…
-
Augmenting SmartSheet
Hi there SmartSheet Community, We are using an existing system for job management and for accounting, and have introduced SmartSheet for the management of project plans. In order to meet the requirement for consolidated reporting of project financials and capacity, we have carried out a deal of augmentation around…
-
Report showing dropdown word and not icon
Hi, i have a report pulling through from various sheets. All reports have a priority column - Low, medium and high. Since yesterday some of the rows on the report shows the words "High" and other shows the icon "!". Is there something wrong with the reporting feature. This was never a problem. I want the ! to show and not…
