Cell linking
Discussion List
- Hey everyone! I seemed to have ran into an issue using a vlookup formula. When I first wrote it out it worked for that cell but when I dragged it down the whole column it no longer worked. =IF(VLOOKUP…
- Hello, What I am trying to do is track overtime hours taken for each department in our company. I have a sheet set up where our HR rep can submit a form for each week's value, but I need to display th…
- I am having an issue where I have a formula working on one sheet but when I copy the formula to perform the exact same function on a different sheet, it does not work. I'm hoping someone could look at…
- I looked into a few formulas to do this such as if statements however I need to use cell linking because the value can be managed on both sheets. So if it changed on sheet A I also need that to update…
- Is it possible to change the value of a certain cell using code in another cell. I would imagine it looking similar to this format.. IF(column@row=X, different_cell=XX, different_cell=XXX)
- Hi there, We have an issue where we provision a project from our intake sheet, but after it hits the project roll up sheet, we can't update the status. Here's a summary of how our workflow: Intake lis…
- Hello, I'm wondering if there's a way to link my sheets in workspaces, we want something that will transfer onto the other sheets or have something in red trigger another sheet into auto generating it…
- hello new to smartsheets. i am looking to make a V lookup that will crosslookup on 2 sheet to tell me if it is on that sheet or not. this is what i come up with so far. =IFERROR(IF(ISBLANK($[Cable Nam…
- Hi, I am stumped at a formula for this sheet. Please see picture below. I am trying to calculate an action taken goal where we take the levels standard, urgent, and immediate and the action taken days…
- I am working on a calendar form and I would like if I entered a specific name of an event, that the next column would autofill a number. For example, if in the "event Name" column I type "Marathon", I…
