I am trying to combine all of the data into one cell for a row, but also any additional rows that share the same PO #. I then plan on taking this information and moving it to another sheet in order to…
Hi. I have a formula in a cell that generates the name of a course using text from other cells (e.g., BUS-430-BL-6W-1D-Master). FORMULA: =LEFT([Subject + Course]2, FIND(" ", [Subject + Course]2) - 1) …
I have two sheets, lets say A & B, which are currently blank and will be used to gather patient information. I'm trying to copy anything entered in sheet A to sheet B including if an updates have been…
Hello, I've done a bit of preliminary research but haven't seen a similar issue discussed. While I know Data Mesh can bring data from a report to a sheet, is it possible to use it to bring over sums f…
In this case, I'll populate a scheduling sheet as seen on top, this will then ideally show up on the 18th of Dec (if it's scheduled on the 18th) as separate rows if possible. Not sure if smartsheet is…
Is there a way [in the Core App - without Control Center] to create a formula that pulls in data from another sheet via cell linking, but is set up in a way that it can be used in a repeated use templ…
When creating a formula you're given the option to "Reference Another Sheet". I love this feature but it needs improvement because it ONLY gives you the option to create a new reference. Yes, you can …
Is there a report I can create that will identify and map out all of the sheets that are linked to other sheets? We have hundreds of sheets, and quite a few workspaces. We regularly link one sheet to …
I have linked 2 cells from another Smartsheet that are child tasks to my project plan. When trying to average the linked cells in the parent task, I am getting a divide by zero error. The linked cells…