Hello, I have been investigating the capabilities of Smartsheet Calendar and was most interested in how to use it to track multiple projects through a Smartsheet Report. The report I've created pulls from several projects, all containing a "Completed" column with checkboxes to mark status for tasks. In setting up a…
Hello! I am working on a column formula for a project plan where the RYGG ball and Task Status will automatically be updated based on the % complete and the due date. What I'm trying to solve for is: if % complete = 0 and start date is today or in the future, then stage is grey and status is "not started" if % complete =…
Creating Dashboard, Sheet to centralized all links to other sheet in a Workspace. I need non Smartsheet user to easily navigate from sheet to sheet to collect data from them. My tasks: Creating Workspace out of a template. Publish sheet Insert hyperlink to freshly created sheet/Dashboard Share Master sheet to non…
Sorry if this is already in the forum. I searched and did not see it submitted as an idea. It only comes up in other discussions. Issue: When using copy to another sheet, the rows do not maintain their predecessor references. Use Case: We utilize Control Center to provision our projects from a standard "PROJECT TEMPLATE".…
Sometimes we need to just delete the dates to start fresh or copy rows to use for another project, but deleting the dates also deletes the predecessors. I was trying to test a schedule template with many hours of work on defining the predecessors. When I wanted to blank out the dates again so it could be used as a blank…
Hi! I am having an issue with using the COUNTIF and HAS functions together to count all instances in a select all that applies column. I'm specifically using this on a metric sheet to add it on my dashboard. Any ideas on what I'm doing wrong?
This discussion has been merged.
Smartsheet Community: Once The Baseline is Set. It Would Be Nice to Have The Ability to Add New Tasks and for those Tasks to be Added to The Baseline without Re-Setting it. Today, I have to Manual Change All the Dates. This Drastically Increase human Errors and is Very Time Consuming.
Is there any Smart Forms Templates that can be used? I wanted to make a smart form that allowed the easy use of Contractor SOW form or something similar to it. I wanted to be able to have contractors fill it out and state their information such as, certifications relevant to work being completed, personnel on site during…
Currently Holidays can be configured in 2 locations on Smartsheet. At the administrator portal and at the sheet level. It would be ideal if at the sheet level you could select pull in holidays from your administrative settings. This should be something you can do when creating a new sheet from a template so that you do not…