-
Double link from cell in other sheet works erratic
HI, I've created a program management tool where we can manage all our different projects. For the moment i'm working on a Charter approval flow, in different stages. Each project manager has his own Workspace, where all his projects are stored. Everyone has at least viewing permission on all projects. All projects are…
-
Can a smartsheet form autopopulate a PDF? Or can you push every row to a recreation of the form (in
Hi, We are using forms to gather group ideas for creative projects. After, we would like to take each form submission or row and populate to a formatted PDF that can be presented to the managers for approval. Is there a way to push a form submission to populate a PDF? Or link cells in smartsheet to a PDF? Or any other…
-
Creating multiple ranges without formula
I have inherited PMO reposinsibility for a large program in Smartsheets. I am going through the process of linking the various schedules, finance/risk/issues registers and other sheets for about 15 projects, all of which link into sub-programs and then up to the overall program. Is there any way that I can go into an…
-
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…
