-
Max Cost per Year
I need to determine the max Remediation Cost PER Year. I also, need to pull this information into another sheet's cell. What's the best way to go about this? This is the formula I have thus far, but it's coming out UNPARSEABLE... =MAX(IF([Date of Incident]:[Date of Incident], <=DATE(2020, 12, 31), [Date of Incident]:[Date…
-
Workflow and cell linking.
I have two sheets that have linked cells. I want to use the workflow to make the tasks from the second sheet disappear if the Status column says complete. Is this possible? I know how to set up a workflow to move cells to a new sheets but it does not seem to be working. Is this because I have the cells linked to another…
-
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.…