Community

Hi:

I have a sheet (target) which has a project ID.

I have another sheet  (source) with 100 columns (which has the project id) 

I want In the target to take about 20 fields from the source and put into the target.

Vlookup is limited as it can't handle more than 20 columns.

and I can't find an

I am using a form to collect contact information for event registration.  We want our guests to register separate email and phone numbers for each member of the household.  Is there a way to create a conditional format that keeps guests from entering the same phone number and email more for more

I work in the IT Department at a company. Another department assigns tasks to our department for software support for a particular application that they use. We would like for them to rank the tasks that they want us to complete - with numbers - 1 through 25, for example. If they create a new task

I've been trying to find a solution to this but I'm coming up empty.  Long story short, we use a Smartsheet form through a web browser on a phone to collect information.  It's sort of an inventory process.  At the bottom of the form there is the option to submit files or photos in which we take

Has anyone try to create a gamification system out of SS (tracking sheet, automation, dashboards)?

Anyone know of a way to batch export or print reports? Planning on running upwards of 50 reports and I want to be able to print through the actions drop down to capture all of them at once rather than opening individually and clicking print one by one.

Hi,

I want to create a formula in a date column that allows me to count all of the cells in the column that are not blank but do not contain a date. I have tried various COUNTIFS but can not seem to find the perfect solution. Thank you for your

Hi all

Anyway to get the row # from a cell value and use it in a formula?

Example

this works:

IF(COUNTIF([Assigned To]$974:[Assigned To]@row, [Assigned To]@row) > 1, "DUP”,1)

Now let's say Column1 row 23 contains the value 974

I would like to do this:

IF(COUNTIF([Assigned To][Column1]23:[Assigned

Is it possible to make a decision tree type project in smartsheet? For example, I need to decide between options A, B, and C that have different cost implications and dependencies, but also need to plan for the potential staff and cost allocation.

As an analogy, let's say a piece of equipment is

I am new to Smartsheet and having problems setting up multiple approvals.  I need to have:  Approved, Approved - Needs More Info, Not Approved.  I am struggling to get the Approved - Needs More Info be an