-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether youโre summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of allโฆ
-
Multi Select
I have a multi select drowndown with users. (for example: Bill, Joe, Ted, John, and Tom) are selected. I am trying to look in another sheet to tell me if these people have submitted a status for project 123. (Sheet 2 is a list of status's submitted: Project | Submitted by | Status 123 | Bill | Green 123 | Joe | Green 123 |โฆ
-
Is there a better way to get the results I am looking for?
Good afternoon, all! I have been tasked with creating an in-depth catalogue of SKUs for my company. Currently, I have a set up that works but is going to be very manual with change management. I have one sheet that is my data dump. It has all of the information located in one spot. I am then going to need to pull thisโฆ
-
How can show difference in answers on same questions in separate sheets?
I have many categories that each have several statements. Each employee will be sent their one sheet and either agrees or disagrees with each statement. Their manager will complete the exact same sheet about the employee. I want the manager to have a report that displays the category and statement where their employee andโฆ
-
Auto Fill Date When Column Checked
I want my date column to auto fill when I check the column Verification and Closure. What formula do I use? I want to ensure that the date doesn't change as time goes on.
-
Convert Column to Formula Error
Hi! The following formula calculates just fine in each cell but when I try to apply it to the entire column via the Convert to Column Formula, it's not working: =IFERROR(WORKDAY([Date Submitted to Courseware]@row , VLOOKUP([Analysis Priority]@row , AnalysisPriorityTypeDropDown2:AnalysisPriorityTypeValue5, 2),โฆ
-
Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values.ย I use the formula countif and only count one time a repeated value when the cell have multipleโฆ
-
Employee Reviews - Pulling & Averaging Category Scores
Hi all, thanks in advance for your assistance! I am working on building a new employee review process for my company and am caught up on one of the final steps. Here's where I am at: I have created an employee review form that individual managers will complete Each employee will have 3-5 reviewers The form submissions willโฆ
-
Invalid Operation Error on Dashboard but not on Report
Hello, I am using the Smartsheet Dashboard to communicate production status to colleagues. I have a widget on the dashboard meant to display the overall status of the manufacturing run by pulling the status of the last item on our task tracker (Condition37). The tracker is displaying the correct status, in this exampleโฆ
-
Need Formula for Subtracting Order Quantities from Inventory Quantities
Hi! What formula would I use in Smartsheet to automatically subtract a quantity from one sheet based on what is submitted in another sheet? I have one sheet that is where we will manage the "orders submitted" and on that sheet is different columns for different items that can be ordered and the quantities requested forโฆ
-
Pulling in data from 1 sheet to another isn't working with any function.
PMO Template - I want to pull in the Project Name Column from the Project Metadata sheet into my custom Attendance Sheet > Project Name Column. I've tried VLOOKUP, INDEX MATCH, JOIN COLLECT, I've changed parenthesis to brackets. I am new to Smartsheets and can't get anything to work. I've watch videos, followed communityโฆ