-
Automate Cell Linking??
I have an smartsheet "employee table" that contains employee names and employee IDs. I also have a smartsheet "activity" that logs employee activity via a smartsheet form. The goal is to pull the employee ID from the the "employee table" smartsheet and copy / input it into the Employee ID column of the "activity"…
-
Full Edit Functionality in WorkApps
I put all the files I needed in WorkApps for efficiency, however, it could have been more efficient if we allow full edit functionality, for example, add columns, cell links etc, that do not require editing your sheets, reports, and dashboard at the Smartsheet application. The intention is to save time and increase…
-
Linked sheet data not refreshing
I’m unable to use a report as I need to pull data from two sheets that I don’t own and do a calculation .. because of this, I insert data from the whole column of the source sheet into mine as a link. Everything works great until new data is added. Most of the time it works .. but I’ve noticed some quirkiness when new rows…
-
Why is there an edit limitation while you use WorkApps?
I put all the files I need into Workapps (sheets, report & dashboard), only to find out that not all the edit functions when you use right click are available. I was trying to cell link but only a hyperlink is available when you edit your sheets at Workapps. Thought it would more dynamic and efficient, but seems like I…
-
Set up correct function (IF, CONTAINS)
Hi, community. I need some help) Here is example. I need function that works like that: 1) take text from List 2) compare to Main 3) if text in Main have on of the word from List, return "yes" Thanks all😊
-
INDEX/Match Error?
Hello, I have the following Equation written out: =INDEX({Brand Manager}, MATCH([Brand Channel]@row, {Brand Channel}), 0) {Brand Manager} and {Brand Channel} are pulling from Sheet A. Brand Channel is a column that is in Sheet A and Sheet B. The equation is written in Sheet B. My expectation of the equation was to pull in…
-
Why do my cells go blank (in both source & destination) when attempting to link cells?
Hi community. I'm new to Smartsheet and while I'm finding it generally helpful and easy to use, I keep getting stuck on cell linking. Whenever I attempt to link cells from a source to destination sheet, link occurs, but the content of the cells in both sheets blank out. I've tried saving, closing, restarting, but continue…
-
Why doesn't INDEX(MATCH) work as intended?
Hi, all: I've recently been assigned to work on a set of tools for my team that have been run in Smartsheet for some time, and am really struggling. Setup: 4 sheets, for 4 separate project-cycle teams. Each sheet needs to refer to the same core set of unique IDs entered in the primary column for Sheet 1. All sheets contain…
-
Index Collect Permissions
Hi all, I have a Smartsheet which looks up values from another sheet using Index Collect, which is working well. However other users with Smartsheet license and with a free license will be loading the sheet who don't have access to the source data sheet. I don't plan in opening the this (the destination sheet) hoping that…
-
Numerical "Priority" Method
Hello, I am in need of a method for assigning priority of a submitted row 1-10. If 1 is selected, the previous 1 needs to become a 2, the 2 becomes a 3, etc. The column needs to recalculate when a row is complete and the 'priority' column becomes blank. I don't think this would be possible without using many columns to…
