-
I would like to copy rows to another sheet but....
I would like to copy rows to another sheet so that other departments can view /work out of the copied smartsheet. What happens if the master's columns are increased or deleted? Is Smartsheet able to match the rows into the correct columns?
-
Finding Duplicate User IDs in one column
Hello Smartsheet community, I'm trying to identify duplicate User IDs in the same column and in the same sheet. The typical user ID has 6 numbers in it (example: 100054). We are working with around 10k user ids. We've tried this formula: =IF(COUNTIF([User - Employee ID]:[User - Employee ID], [User - Employee ID]@row) >…
-
Is there a way to auto-group form submissions/rows on the source sheet?
By default, the information that is submitted via a Form populates the Sheet's rows in oldest-to-newest order. I'd like to have the information submitted via the Form auto-group/sort according to the values in one or two of the Sheet/Form fields once it is populated to the Sheet. Would anyone be able to guide me on whether…
-
Assigning One Person to Another Person
I have AR Specialists that are assigned to Property Managers. Each time I enter a new property and select the Property Manager from the drop down list, I want the AR Specialist column to automatically populate. If the Property Manager in column 1/row 1 = XX or XX or XX, then the AR Specialist = XX If the Property Manager…
-
Capture cell changes in automation
Hello, We have an application that tracks users' PTO requests. Sometimes they need to change the date on which they are taking vacation. We have an automation that runs, when a date is changed, to notify their approver to re-approve the request. I can change the message for changes so the approver knows it's for a change…
-
VLOOKUP Formula
Hi Smartsheet community! This may seem like a simple question but I cannot figure out this formula for the life of me. I am trying to do a basic VLOOKUP formula. On sheet #1 I will have a column that lists employee alias's and a column that will VLOOOKUP that same alias's level from sheet #2. On sheet #2 it will be a list…
-
progress percentage cell not accepting formulas
Hi, I have a column to display the percentage of completion for each row, I would like to use something like the below formula in this cell, to automatically update this value, however, Smartsheet is not interpreting this as a formula, instead, is putting a ' sign before the = sign '=IF((Status@row = "Done"), [%…
-
Use smartsheet to autofill / export excel spreadsheet
Hey! Can anyone help with this question: Similar to the "form" function in smartsheet, I can generate a survey-like webpage where users can fill in info for different columns. On the other hand, users want to upload a spreadsheet with e.g. 10 records. My target is to apply the info user filled in in the first "survey"…
-
Automation for changing value to a cell
I wonder if there is a way in which through an Automation I could change the value of a cell,,... not asking for an aupdate,.. I. E. Someone updates Field "Action", and once the pèrson send the update, the field "State" change to the value "Done"
-
Is it possible to send specific columns of two spreadsheets to a third one?
Hi everyone I have two spreadsheets and I want to take some columns of sheet 1 and others from sheet 2 and put them in a third one and that every time an update is made in sheet 1 or 2, it also apply on the third one. Including new rows, deleting rows and changing data. I am working with many data. Thank you, Belia Báez
