Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts L…
Is it possible to create an automation that will populate a cell with a formula instead of text or a drop down value? I am trying to get a column to populate with the name of a user who checked a box.…
Hi All, I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet? Thanks
Hello, I am working on a table and am using a countif formula that references another sheet. I then want to copy paste this same formula across a few more cells but would like to change the reference …
We have a blueprint set up that has a summary section with cell links in our template sheets to navigate between the other template sheets/dashboard for our provisioned projects. We also have project …
I discovered last week that linking cells between sheets does not work if the cell being linked to is restricted to a date. Smartsheet technical help confirmed that this cannot be done. I'm not sure w…
My attempt: Step 1: Sheet #1 get populated with new values (via a form submission(s)) Step 2: When Sheet #1 has a new value/row, only certain columns get populated into Sheet #2(i.e. ID number, case n…
Good morning, I am facing an issue on my smartsheet, i have a column (dropdown list type) that allowed multiple values per cells and i am trying to manage these different values in order to concatenat…
I am creating an simple method to help us determine project progress to report back to our customers. The idea is to group tasks into phases and then classify each project as being in a specific phase…
Has anyone had any issues with column headers moving around the sheet automatically. I have multiple sheets referencing each other using vlookups to report back and also to use tools I have created. T…
