Hi! I'm new to the community and already raising an issue. Sorry about that! If anyone can help me with this, I'd greatly appreciate it. I'm trying to use VLOOKUP within a Product Roadmap sheet to set…
Hi there, I am trying to have a graph display the count of some things across multiple sheets (~40), as shown in the screenshot. The only way I could think of for now was to get the data by cell linki…
Here is my situation: I have a PMO tracking sheet that is tracking many projects through various statuses. I am putting together a metrics sheet so I can create charts to put on a dashboard. In the me…
I have created a set of sheets that I will use to managed various parts of a Project. Between the sheets, I've linked a number of cells, pulling data from one sheet to another. As I'm going to run thi…
I am new to cross sheet formula's and a formula that works locally on a sheet, I am trying to cross reference so that the data that I successfully found will be on another sheet. Here is the formula t…
I have three different gantts with some summary data that is fed into the main project data sheet. Only one of the gantt sheets is used in a project, so I thought of linking each of the gantts' data (…
Hi, Due to the limited restraints on the # of rows (5,000) in Smartsheet - I need to create a formula that references multiple sheets for a match statement. See below: =IFERROR(IF(MATCH(([Employee ID]…
I am trying to perform a Global Update to all of our existing projects to include additional data for us to report against that is currently captured on our Intake Sheet. I have been successful in add…
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, c…
Please help haha It is difficult to put into words exactly what I am trying to accomplish, but I'll do my best. Please ask questions if I'm not being clear enough. Example: I have a material column fo…
