-
How to show most frequent status per unique groupings?
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also…
-
Index Match Multiple Criteria across sheets
I am trying to create a formula that matches criteria between two sheets, then populates a cell based on the criteria's results. The goal is to use an index/match to populate the "fee" cell in the second picture based upon the client and service level. Could someone explain how to create this formula? Thank you.
-
Solutions for Cell Link Issues in Control Center
Is anyone else experiencing issues with cell links either being stale (showing old data) or not working at all (red link indicators)? My organization uses a lot of cell linking in our blueprint and since August we have had issues with this occurring randomly throughout provisioned projects. We haven't gone a month without…
-
Index Match not working
Hello, Smart community! I have something that seems VERY simple that just doesn't want to work. I'm using Index/Match. The sheet I'm referencing has a Primary Column (QMS) with a numbering system to identify if it is a Risk (R) or Opportunity (O). I have put in 17 rows of "R"s (i.e. R01, R02, etc). The sheet I'm trying to…
-
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…
