Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Index and Match Vs Vlook upIn Formulas and FunctionsHi all, I was advised to use Index and Match as I am pulling dates from various schedules into one sheet. Last time Vlookup worked really well however there was a limit of 25000 links. Now I am using index and match and the limit is even …Answered - Pending Review 2 views 2 comments 0 points Most recent by Avinash Chandra Formulas and Functions
-
DuplicatesIn Using SmartsheetI have a student sheet that I am copying over for the next semester. I copied only the data but didn't want the comments, attachments, filters, links, etc. However, there are duplicate names on sheet and I want to know if there is an eas…
-
Resource managementIn Formulas and FunctionsI was trying to use the resource management function of Smartsheets, but that really is not giving me what I want and it is pulling from sheets the Assigned To is on, but I do not want to include in my resources. So I thought I might be a…Answered - Pending Review 12 views 2 comments 0 points Most recent by Kimberly Washeleski Formulas and Functions
-
IF AND statementIn Using SmartsheetI am attempting to build out a system which checks a box based on a hidden checkbox and a drop down field. If the hidden checkbox is checked, and the dropdown field shows either "In Progress" or "Not Started" the visibl…
-
Using If Formula to Populate Status of Parent RowIn Formulas and FunctionsI am looking for help writing a formula to populate a parent row of a Single Select Dropdown column. The Parent row should reflect the Status of the Child rows - for instance, if any of the Child row statuses are set to Not Started, In Pro…Answered - Pending Review 17 views 3 comments 0 points Most recent by Bridgett Alonso Formulas and Functions
-
Using COUNTIFS with CONTAINSIn Formulas and FunctionsWhen I try to incorporate a CONTAINS into a COUNTSIFS i keep getting errors Works fine: =COUNTIFS({JSA - Daily Job Start Safety Form Range 1}, [email protected], {JSA - Daily Job Start Safety Form Range 2}, $Date$1) Incorporate CONTAINS : These ar…Answered - Pending Review 12 views 2 comments 0 points Most recent by Nicole Paulsen Formulas and Functions
-
INDEX() function helpIn Formulas and FunctionsHi, I have a master list of tasks in one sheet with project specific labeled columns. I'd like to break out those columns into separate sheets. My thought is the best way to keep the master list current while transposing data, using a com…Answered - Pending Review 2 views 1 comment 0 points Most recent by David Tutwiler Formulas and Functions
-
Help Creating a formula using ChildrenIn Formulas and FunctionsHi! I currently am experimenting with Parent and Children Hierarchy to clean up my sheets. Below is a screenshot so you can see my mock up page. The issue I am running into is when I add an additional "Project", my formulas in t…Answered - Pending Review 11 views 1 comment 0 points Most recent by David Tutwiler Formulas and Functions
-
Today / Yesterday formulasIn Formulas and FunctionsHi all, I need to create a dashboard to include all calls made to clients, either today or yesterday (the idea being that the charts would change on a daily basis). My issue is that I don't think I can use the Today or Today -1 type formu…Answered - Pending Review 12 views 5 comments 0 points Most recent by David Tutwiler Formulas and Functions
-
Contact List is NOT restricted in ReportIn Using SmartsheetI'm wondering if someone knows what's going on here! In our main sheet, the contact column (Crew) is restricted to 2 contacts, but in the report that drop down is showing many other contacts. I have the contact column in the main sheet set…
