-
I want to stop updating all instances of cross-sheet reference
Hello, I am working on a table and am using a countif formula that references another sheet. I then want to copy paste this same formula across a few more cells but would like to change the reference column for each new cell. However, when I change the reference column on one cell, it then updates all instances using the…
-
How do I fix cell links from breaking after adding a new template sheet in Control Center?
We have a blueprint set up that has a summary section with cell links in our template sheets to navigate between the other template sheets/dashboard for our provisioned projects. We also have project metadata sheets that hold data we want to show in the summary sections. I recently had to create a new template sheet to…
-
Linking Cells with Date Restricted Format
I discovered last week that linking cells between sheets does not work if the cell being linked to is restricted to a date. Smartsheet technical help confirmed that this cannot be done. I'm not sure why this is the case, but this seems like important basic functionality, and from a user standpoint, I see no reason why we…
-
How do I move certain values from one sheet to a different sheet?
My attempt: Step 1: Sheet #1 get populated with new values (via a form submission(s)) Step 2: When Sheet #1 has a new value/row, only certain columns get populated into Sheet #2(i.e. ID number, case name, details) I tried the automation feature, but the whole row gets copied. I want it so that only certain…
-
Manage multiple values in a cell from a dropdown list
Good morning, I am facing an issue on my smartsheet, i have a column (dropdown list type) that allowed multiple values per cells and i am trying to manage these different values in order to concatenate them the way i want in another cell. Does anybody knows the way to pick a single value from all of them or even the way…
-
Project Progress/Reporting
I am creating an simple method to help us determine project progress to report back to our customers. The idea is to group tasks into phases and then classify each project as being in a specific phase depending on which tasks have been complete. Once all tasks in a phase have been completed, the sheet will report back that…
-
Columns Moving Automatically
Has anyone had any issues with column headers moving around the sheet automatically. I have multiple sheets referencing each other using vlookups to report back and also to use tools I have created. Therefore the location of certain columns are highly critical to my companies daily workflows. I have already confirmed that…
-
Cross Sheet Reference stopped working
We currently have a Pharmacy Site API reference sheet that is updated daily at 2am PT. Since its a complete rewrite, the sheet is deleted then generated every morning with the new updated site information. This master sheet is indexed across several hundred Smartsheet solutions within our company. I have a specific sheet…
-
How to automate or move cell values when a date is in the past week?
Here is a tracker of a 10-weeks look ahead of number of hours to spend in project from Monday-Friday which are highlighted in blue cells. The Start Week and End week changed if a date is based on current week. Which means 9-Jun-2024 will be the current week by next week , correct? The problem now is the no. of hours is…
-
Data mesh cell history
Hello! I would like to make a suggestion regarding cells that are populated via Data mesh. As of right now, when a cells gets populated via Data mesh and you click on View Cell History, you can see the name of the person who owns the Data mesh. However, you have no idea if the person manually input that information or if…