-
Assign Tasks to people without they having to see everyone elses task
I have created one master sheet with ask entire list of task with assigned to column. I want to create either new sheets or reports what every person has their own task list and they cannot see other people's task. Is it possible. In their own report or sheet they should be able to comment and add details to the columns…
-
How can I update cell links across all of my projects?
I added Profile Data to all of my projects via Global Updates. They are dates that are subject to change (at least one or more times) & cannot be filled in via formula (right now they are blank & waiting to be filled in as needed). They appear in the Metadata sheets as well as another template sheet--this template sheet is…
-
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…
