I received this message after submitting a ticket to Smartsheet. As there seems to be no end in sight I'm curious if anyone else is having the issue and if they have found any solutions to resolve it? ---------------- I'm from the Escalations team here at Smartsheet Support. I was looped in explaining that you are seeing…
Hello! I have been tasked by my team's leadership to create a way that they can audit how often my colleagues are updating their project plans. We currently have a "Master Sheet" that lists all of our current projects and certain cells linked in from each project plan. The project manager is supposed to be updating their…
My issue is this: I have a master sheet with material types (A1,A2,A3 etc..) and total material quantities (#'s). The other sheet I am using is updated via forms. The form is used for distributing materials and requires a material type, and material quantity before submission. Once submitted I would like the quantity to be…
I have a template sheet which is used for many other sheets but my managers keeps moving the goalposts for part of the reporting meaning i have to update a formula on the template then copy and past into the other 18 sheets currently in use. Today i set up a new sheet i thought i would try linking the formula cell to the…
I have linked a cell in a template sheet to the same cell in the various iterations of the template but unable to then convert the formula in each sheet to Column Formula. Could this be considered as it could save a lot of time if a formula needs changed for any reason as updating the template would automatically update…
I am having an issue where I am in a new Program and when I create a new project (automation set up to create a project based on the type of project entered into the intake form), the fields I have selected to create cell links in the Summary Section of the Task List isn't creating the links from the Intake form to the…
I am using Smartsheet to create a calendar system for reservation of a shared resource. So far, I have not been able to find a way to add TIMES to Smartsheet so more than one person can schedule the same resource on the same day, during different time slots. Can you help? Furthermore, these resources are occasionally…
My team is trying to create a "wrap up" type sheet that pulls data from child sheets that are updated monthly from a form. The data in the child sheets that needs pulled are the most recent submissions from forms associated with the child sheets which means the cell will constantly change. Is there a way to link these…
I've got 2 spreadsheets for tracking job progress. One is an end of day report filled out by field personnel. The other is a collection of all the information about various jobs gathered from the end of day reports and manually entered data. I want to link a checkbox when any end of day report has a "Install complete"…
Hello, I am currently working on a formula for the health column in my smartsheet that is based on the the task status and the end date of that particular task. This is what I have so far but what I need is for when the "end date" cell is blank I would like for the health of that task to be blue. The reason is we do not…
