-
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…
-
Cell values automatically reverting to previous values. Changes won't save.
I have a very serious concern. I am updating the contacts column to change the contact from Richard to Teresa. However, after about 10-15 minutes Smartsheet automatically reverts to the original contact. This has been happening for a week . I am very concerned because how can I be assured that changes are saved in all my…
-
Automatically linking cells when a new row is added to a sheet
I have two sheets. Sheet 1 contains primary data, the other secondary. When a new row is added to sheet 1 I want to be to create a new row in sheet 2 that contains the information in specific cells from sheet 1. I want that link to work such that if Sheet 1 is updated that is reflected in sheet 2 - the sheets stay in sync…
-
Collaboration with multiple sheets and a single, "external" user.
Hello, We've built an environment for our budget process that has a dedicated Smartsheet for our various regions, each of which has a dedicated Dynamic View. This allows our HR team to work collaboratively with our Finance team. The HR team has access to the underlying sheet while finance has access to the Dynamic View. We…
-
Attendance reports
I am trying to create a sheet for attendance reports. We take daily attendance of our students, but it is done on a form which is part of a bigger report. I would like to provide the front office with a monthly report of just the students that were absent and which days. How would I do this? Hyperlink? Condition? Please…
-
Is it possible to remove a cross sheet reference when a condition is met and keep the data?
I have an interesting scenario where I have a cross sheet reference that pulls a current outstanding total from another sheet. This works perfectly but we want to keep history of what this total outstanding value was at the end of each day. The image below should help explain the scenario. Essentially what I want to do is…
-
I need help rolling up multiple weeks of data into one response based on specified criteria
I currently have a sheet that collects weekly attendance info from multiple stakeholders (for the purpose of this question we can just look at the Coach Info columns). There are 3 responses that can be put into this column: 'Yes', 'Some, and 'None'. My second sheet is a monthly tracker in which I am trying to read four…
-
Cell linking automation
I've been able to link cells from sheet to sheet but I can't find resources or videos on how to automate the process. I have to manually type the formula in the column of the other sheet whenever a new row is added to the master. I have a master sheet. When a certain status is selected at a row level, I would like to…
-
Linked Source Sheet Not Automatically Updating
Hello, I am working on creating a sheet that utilized data from a master sheet via links. I am struggling because the new sheet is not automatically updating when new info is added from the master sheet which essentially makes it useless. Is there a way around this? For what I am trying to create, I need the full…
-
Formula Assistance with Linking Sheets
Hi! I have created a sheet that uses a form for requests when my company is wanting a physician to travel. This includes what center/state they're traveling to, their home center/state, the district manager that oversees each center, etc. When a physician is selected I would like for the home center, home state, home…