-
Formulas in Automations
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. For the action block of the automation, I selected Change Cell Value in Column to =([Modified By])@row The automation…
-
Get a list value from another sheet
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
-
I want to stop updating all instances of cross-sheet reference
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 column for each new cell. However, when I change the reference column on one cell, it then updates all instances using the…
-
How do I fix cell links from breaking after adding a new template sheet in Control Center?
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 metadata sheets that hold data we want to show in the summary sections. I recently had to create a new template sheet to…
-
Linking Cells with Date Restricted Format
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 why this is the case, but this seems like important basic functionality, and from a user standpoint, I see no reason why we…
-
How do I move certain values from one sheet to a different sheet?
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 name, details) I tried the automation feature, but the whole row gets copied. I want it so that only certain…
-
Manage multiple values in a cell from a dropdown list
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 concatenate them the way i want in another cell. Does anybody knows the way to pick a single value from all of them or even the way…
-
Project Progress/Reporting
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 depending on which tasks have been complete. Once all tasks in a phase have been completed, the sheet will report back that…
-
Columns Moving Automatically
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. Therefore the location of certain columns are highly critical to my companies daily workflows. I have already confirmed that…
-
Cross Sheet Reference stopped working
We currently have a Pharmacy Site API reference sheet that is updated daily at 2am PT. Since its a complete rewrite, the sheet is deleted then generated every morning with the new updated site information. This master sheet is indexed across several hundred Smartsheet solutions within our company. I have a specific sheet…