-
Copy value from one cell of the same row to another
Hello, SmartSheet community. Does anyone know if there's a way to automate for new row created/existing row updated event to grab the values from one column and paste it into another column of the same row? Both columns are pull-downs. Source column has a pre-defined list of users where one or more user can be selected. I…
-
Random assignation
Hi, I'm trying to assign a task to one of my team members (there are four). Every time a new project is added to the queue, instead to manually add one of them, i would like one randomly chosen person among them four. Can you please help me to get this? Thanks in advance! Alberto
-
Update Multiple Columns with Single API Call in Bridge
I am trying to update multiple columns' properties using a single API module in Bridge. I am pretty sure my Request Body is formatted properly. I have used "PUT" and gotten the standard 404 message. I also tried PATCH and got this: "<!doctype html><html lang="en"><head><title>HTTP Status 501 – Not Implemented</title><style…
-
Formular Workday Count
Hello, I've formula use Workday to count Due date = Start Date @row cell + option days. fx Image below: Start Date is 04/24/25, then added 11 days = Resulted 05/09/25 as Due date. Now, out of curiosity added days manually = Resulted 05/08/25 as Due date. Some folks prefer manual counting😓. And I need to able to understand…
-
Moved: Formular Workday Count
This discussion has been moved.
-
Are New Folders No Longer Allowed In Sheets Directory
Not sure when this changed, but it was recent. I used to be able to create folders for organization within my Sheets directory. Now there is no option to do so. The menu options are gone. If I create a folder in a workspace, I cannot drag-and-drop it into my Sheets directory. Right-clicking "Sheets" in the Browse panel no…
-
👀 Hear Me Out… What If We Stopped Calling It “AI”? 🤖🧠
Artificial Intelligence has changed everything — how we work, think, create, and even how I manage to look like a genius when someone needs a policy or SOP written on the fly. But lately, I’ve been stuck on one little detail… Why do we call it artificial? There’s nothing fake about what it does. It learns, adapts, helps us…
-
Limiting Information on Child
Hi, My parent sheet has an automation with certain conditions (If department "A", and Type of Request is "A") to copy cells to another sheet for individuals that only need limited info. This works, and is great, but I want to limit the information even more (no attachments, no reasoning column). How can I accomplish this?
-
Reference or copy a column in one sheet to another sheet automatically
Hi, I am trying to figure out a way to automatically get specific columns in one sheet, into another sheet I was originally looking at using a workflow to copy the rows over, but I only wanted to copy a subset of the columns which doesn't look to be possible. Then I started looking at cross-sheet references, but the posts…
-
Have a column with different values and trying to create helper column to assign number
Have a column where freeform module numbers are entered (i.e. 101, 204, 300, S811). I want to create a helper column, where it will read the module number and assign a single digit. (i.e. 101, 104, 141, will all return "1" in the helper column and so on)
