Cell linking
Discussion List
- Hi, I have a status column in my row that changes from "animating" to "approved" and would like the start and end date columns to update when status is changed. ie: 1. When status column changes to "a…
- Hello, I have two separate sheets that need to be connected. One is an inventory sheet of all raw materials in stock, and the other is a record of all raw materials delivered. If we receive a delivery…
- I need a solution to the vlookup max reference cell count of 25,000. I have a database that zapier loads data too from an application. The database consists of 134 columns, and will grow to an estimat…
- My apologies if this has already been covered, but I didn't see anything specific to this subject when searching. I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 colu…
- Hello, fairly new to Smartsheet and I have a question. We have a sheet for PO requests and one of the columns is for "Status" , it has several options from a drop down menu. What I would like is for o…
- Hello, I am having a webform insert new rows at the top of my spreadsheet. As you can see in the picture, for some reason the formula in the third column automatically fills the new row, but the formu…
- Scenario: In our project, we have a weekly reporting cycle. In some of our sheets, we have a field that is "previous status" or "previous actions" or other similar ones, you get the idea. Desired acti…
- Hi All! So I have a sheet with a list of tasks, a checkbox for completion and a due date. In one of my other metrics sheet, I am trying to generate a list of my top 5 overdue tasks. I have managed to …
- Hello I have created a Time sheet form that i sent out to 11 employees to gather all the daily info. This form fills in the Time sheet Smartsheet. We want to keep the Time sheet Smartsheet as a master…
- Hello Everyone, Does anyone know if it is possible to create a master sheet, then once a row is added to this sheet, the same row (With only specific columns) could be automatically added to another s…