-
turn a row in one sheet to multiple rows in another sheet
I want to create a "task list" so when I complete a row in one smartsheet(sheet a), I wat to break that into 10 "to-do" rows in a second sheet(sheet b). is there a way to do this? essentially what I am trying to do is for every row in sheet b, I want to send a separate request for update. i have datamesh if that will help
-
Taking quarterly goals and putting them into Smartsheet
I have a general table I use to keep track of goals for a sales team. I think they're relatively simple, but I'm having a heck of a time trying to get them into SS. The things I need to track: Goal value - numbers, for example $62,000 Actual QTD - numbers, for example $50,000 % to Goal - numbers, Actual QTD shown in % form…
-
Unable to Edit 1 Column on a Spreadsheet
Hello all, I am working on a collaborative spreadsheet on which I am an administrator. All I am trying to do update a vlookup function for one column, which references a different spreadsheet, on which I am also an administrator. The spreadsheet is currently some 40-50 columns wide, but for some unknown reason I am unable…
-
how do i import multiple large googlesheets, with multiple worksheets, and then integrate them?
Hi, I have inherited several google worksheets. each worksheet is stand alone, with about 20+ workbooks per sheet. the first several workbooks of each sheet are basically summary dashboards of the remaining workbooks. so there's lots of vlookups, sumifs and so forth. When I try to import, of course only the first sheet of…
-
Copying and Unlinking Cell Data
Good morning, I have a master list of all of our projects comprised of linked cells from our project schedules -- so it updates as the projects update, providing a summary status overview of the percent complete on all projects. I want to track our progress month-to-month to determine how much progress was made during a…
-
Baffled......Circular / Blocked Reference (Vlookup)
This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but I don't understand why my sheets work perfectly for periods of time, and then start…
-
Functionality of dashboard with Forms on it
Hi, Created 3 forms for doing employee reviews with underlying grid sheets. 1 form is an Employee Self Review, 1 Form Employee Selection, and 1 Form Reviewer Form. Idea is a employee fills out self review, then sits with manager. Manager opens dashboard, selects Employee from Employee Selection Form, then clicks submit.…
-
COUNTIFS returning 0
I am having an issue with the formula below. I am attempting to get the count where the year of {Conv Rec 020} equals the cell "2020" and the month of {Conv Rec 020} equals 1 (aka: January). I have quoted the 1 and get the same results. The formula is returning "0"... any thoughts to return the correct values? It should be…
-
Filter View Access for certain users
Hi everyone, I am using Smartsheet to implement an AM (additive manufacturing) order tool for a SME, which uses AM for prototyping. Objective of that project is to directly set an order out of the CAD programm (STL-file, part specifications) into Smartsheet, which will automatically send a notification to the supplier, who…
