-
Display sheet name/link on form
It would be helpful if somewhere on a form it included the link or at least name of sheet it is connected to. Our team is currently having an issue finding which sheet a form is connected to. Granted, this is an odd problem because we typically know this info. However, we receive requests from multiple departments that…
-
Check a box when a match for a value is found on another sheet
Hi everyone, I have a sheet called Parts Database used to track parts as they go through a production process. Screenshot below. Currently, workers check off the status of each part as they go, which is not practical with the quantity of parts. Ideally, I want them to be able to fill in a response form at the end of the…
-
Please bring back the tabs...
The new December 2018 look prevents easy navigation and inhibits work-flow. This is not a positive update. I see numerous posts expressing the same opinion. Please bring the tabs back or make them an option.
-
# of tasks based on due date and owner
What Smartsheet formula would be best to get the count of tasks due within 10 days if the owner equals "client"?
-
Working Days
Greetings, I have the start day and the duration. Is it possible to calculate the end date using these two entitites such that only working days are included (only monday through friday and not the weekends)? Thank you
-
Percentage Complete of child tasks
Hello! I'm trying to figure out a formula to do the following: 1.) Display percentage complete of tasks marked "complete" within a child group, at the child top level 2.) Display percentage complete of child groups in the parent row. Note that I am not using dependencies, and am using an independent "% complete" column (I…
-
Last value of a row that is not empty
Hello everyone, I have to make a milestone tracker that I update week by week by adding a new column (the rows are the projects). I can't just modify a column because they require me to keep a history of the data. columns (date type) can contain a value or be empty. I need to get the last updated date for each project (not…
-
Creation of new projects and sync between SS and RM to be both ways, rather than just SS to RM.
For general project forecasting, I would like to create a project in Resource Manager and assign resources. I would like this to autogenerate a sheet in my Smartsheet Portfolio Folder that holds all schedules in use by Project Managers. In other words have the creation of new projects and sync between SS and RM to be both…
-
RTF in Dashboard Widget
I downloaded an example dashboard which tracked multiple projects. Looked good and decided to build my dashboard to match example. Example dashboard has a Rich Text Widget which has multiple formats within. However when I try to use the rich text widget it does not allow me to have varied formats (different text sizes,…
-
Stacked Bar Graph - Reflect 3 columns
Can't figure out how to use 3 columns for a staked bar chart in Smartsheet. Please see attachment. For example, I'd like one column to show all costs for January, with Amy and Joe's costs would be broken out by color. Is this possible? If yes, could you please explain directions? I can only figure out how to use two…
