Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
IF Formula referencing one column to fill in another
Hi - I've been reading through the community posts and trying a variety of answers, but nothing I've tried seems to be working so I thought I'd post and ask for help. :) I am trying to establish a column that has an answer based on another cell. My columns: Dept Automation Lead So what I'm trying to create: IF Dept =…
Contacts list on webform
I would like to use the dropdown list of contacts in a web-form, does anyone know if this is possible? thanks Adam
Contact List [Assign To] and auto-populating this field
In a Project Template Smartsheet, I would like to auto-assign a value to the " Assigned To" column when form data is uploaded. The "Assign To" column is a Contact List type. I would like the "Assigned To" column to auto-select a value in the Contact List based on the form OR another column in my Project Smartsheet. Is this…
How to index + match with multiple criteria ?
Hi! I'm trying to figure out how to do the following excel formula in Smartsheet, but I am having trouble with it. Can I get some help please ? Basically what I need to do is match 3 different criteria (lookup 1 -3) with 3 different collumns(part 1 - 3) and when those match they have to give me the corresponding Time. This…
Managing Contacts
I'm a new user. I imported all of my Outlook contacts and now realize I only want a few of them in Smartsheet. Is there a way to delete all at once and start over? So far, I've only been able to delete one at a time. Thanks.
Using Hierarchy Formulas & Conditional Formatting to Color Code Rows in a Sheet
I’m always interested to hear if someone else has figured out a better way to do something, so feedback is welcome and appreciated! (: Example Sheet: Hierarchy Formulas & Conditional Formatting I like to use colors to help guide me through a sheet and I have settled on a process that works for me. *See Picture* Minimum…
Comments Report
Hello, Is there a way to get a report of all the comments that have been entered a give week for a given user? Thank you, Lisakay
Give access to a WorkFlow?
We have a few shared sheets for which we need to adjust the Jira Workflow from time to time. Currently, the creator of the workflow is the only one that has access to it. Is there a way to share the workflow with others so that more than one person may make changes? Thanks.
Sight form links update when making a folder copy
Hi, May be i am missing something, how can i attach forms to a sight so that when i make a copy of the complete folder (with sights, sheets and reports) the form link is updated as well, just like sheets are. Greetings Gijs
Creating a Sum for Filtered Rows
I have a Sheet which contains a complete list of all invoices, which Customer they are for, the Invoice Total and an Invoice Paid column which would show the balance of the Invoice. I have created a number of Filters for all of my Customers, so that I can filter straight to one Customer and see their outstanding balance.…
