Hi everyone I have two spreadsheets and I want to take some columns of sheet 1 and others from sheet 2 and put them in a third one and that every time an update is made in sheet 1 or 2, it also apply …
Hello, I have a sheet with a column of cells with formulas in them. These formulas produce numbers. Then I have a second sheet, where I have a formula in a cell that references the first sheet's colum…
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 …
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 a…
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 pr…
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 i…
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 work…
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 a…
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 va…