Formulas and Functions
Archives for May 2021
Discussion List
-
Duplicating a column of data from one sheet into anotherIn Formulas and FunctionsWe run a Master Sheet containing many rows (Projects) and columns (works required). We would like to share a smaller number of columns to an external party. Normally I would create a Report, select the necessary rows and hit Publish, howe…Answered - Pending Review 16 views 4 comments 0 points Most recent by Mark Cronk Formulas and Functions
-
Merging A list to show unique value/identifierIn Formulas and FunctionsHi Smarties, I am wondering if anyone could share some ideas on this. I have a list of available products. Some of these products are repetitive in the list. For example I would like to show a list of AVAILABLE products in the dashboard,…
-
Formula ChallengeIn Formulas and FunctionsHi Smarties, I am trying to get this formula right in the Formula Challenge from Smartsheet. I am not sure what I did wrong so hoping fellow Smarties could help! In the Parent Row symbols column, write a formula that returns the most co…
-
Automatically Select Contact With Column FormulaIn Formulas and FunctionsHi, I am fairly new to smartsheet so I apologize if this is a basic question. I am trying to automatically populate a contact column with a single contact indefinitely. For context, it's just so that in a separate report that pulls from ma…Answered - Pending Review 59 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Parent-Child: Collecting Child InformationIn Formulas and FunctionsGood Day Smartsheet Community: Does anyone have a Formula that would Collect info from the Child and place in the Parent Cell? For Example: Parent Cell Result: Red, Blue, Green Child Info: Red Blue Green Thanks
-
Count if with Multiple ColumnsIn Formulas and FunctionsHi, This might be a simple question but I've been a little stumped by what syntax to use and hoping you can help. I have one column (Test Case Type) that has 3 options to pick from 'Original', 'E2E', or 'PAT'. I have Another column 'IC Rev…Answered - Pending Review 13 views 2 comments 0 points Most recent by Tim Pruitt Formulas and Functions
-
DuplicateIn Formulas and FunctionsHello, I was able to find a formula that works to ignore blank cells and identify duplicates but the first entry is also being labeled a duplicate. Is there a way to ignore the first entry and only add duplicate to all proceeding? =IF(AND…
-
I wish to count column A with a fixed value, with a unique date in Column BIn Formulas and FunctionsColumn A Column B Smith 5/27/21 Jones 5/27/21 Smith 5/29/21 Smith 5/27/21 I want to count column A with "…
-
IF Statement with nested ORIn Formulas and FunctionsI am trying to write a formula and I am not entirely sure if it is possible. I have 3 columns, Status, Internal only, and Archived. I am trying to write a formula for the status column to mark it Green, Yellow or Red. If the archived colu…
-
Collect hour and date - Task completedIn Formulas and FunctionsHi, Is there a way to have a column who collect automatically date and hour when an another column has a check box check?Answered - Pending Review 1 view 3 comments 0 points Most recent by Andrée Starå Formulas and Functions