-
"Task Status" - custom status set up
I used the "Project Tracking and Rollup template set to get started on tracking certain tasks for a project. it looked like it came with pre-populated options for task status (On Hold, In Progress, Not Started, Complete, Canceled). I added a couple of my own statuses (see attachment) but the task rollup report only shows…
-
Can I use the data linked from another sheet, to populate my Sheet Summary?
Hello, I have this sheet I'm using to track projects status and health. Almost all data are coming from my team's project plans, and I use therefore the "Link from cell in another sheet" option (this way everything is automatic and I don't need to have manual updates). In the Summary sheet, I have setup a field in which I…
-
Blank spreadsheet
A file was shared with me (with limited permissions), the owner set a filter to limit what can be seen of the file. However, when I go to view the spreadsheet I only see blank cells. I have no way of turning off the filter. What am I doing wrong?
-
Documenting a complex workflow with formula
Hi community, i haven't found anything yet in the community so my question is easy. I've built a complex worklfow with 80+ calculated columns and 20+ unique workflows with a lot of vlookup's and referenced to other sheets in the drive. Now it's time to document the work properly in a way that somebody who has no clue about…
-
Parent Row Calculation
Hello. I want to know how exactly the the Complete % of the parent row is calculated by Smartsheet. I though it was the average of the child row but I think I am wrong. As per the attached picture you can see the average of the Complete is % 0.24 i.e 24% where as in the parent row its only 12%. Please explain me how the…
-
Smartsheet integrating with gmail add-on error
I get an error message randomly when I get to the final step in adding an email to my sheet. It says - Your changes could not be applied. Please check “. This doesn’t happen all the time and is not consistent.
-
Report from multiple sheets
Hi, Can anyone suggest me how to retrieve data from 2 sheets into a report? Here is the list of fields from sheet1 and sheet2 Sheet1: program, task name, release name, field4, field5... Sheet2: program, release name, field3, field4,field5.... Program and release name is the common from both the sheets. Sheet1 has main and…
-
Automated Update Requests
We are moving from manual to to automated update request but it appears that the locked field functionality isn't working. When we send manually the fields are locked. In the automated request the locked fields are editable. Thanks !
-
Remove Extra Decimals When Not Needed
I have a column that lists project numbers. Some project numbers have "point numbers" which are shown as two decimal places. The problem is I need the projects that don't have point numbers not to show the ".00" after them. Is it possible to do this? This is an intake sheet for Control Control Center, and the value is…
-
Replacing Smartsheet Colors with Custom Colors
Hello - I know through settings we can add our custom colors to change the background and taskbar of our sheets; however, does anyone know if it is possible to change the standard colors for ALL functions in Smarthseet and make them custom? See example graph - we'd like to change the bars to be custom colors for example.
