-
Returning Non Duplicates when comparing two Multi-Select Columns
Dear Community Is this possible in Smartsheet? I just can't seem to return what I need! I've been playing with Join(Collect()) type statements but maybe I have overcomplicated it! Scenario and requirements are explained in the screen shot. Happy for you to say Column 1, Column 2 and Column 3 in any suggested formula, as my…
-
Index Match not working with multiple options
I am trying to get a formula to work with multiple options selected in the reference sheet. The reference sheet has a Unit column and multiple contact columns. The contact columns are based off the roles within the unit. I have several formulas based off the Unit column. Some units have the same contact list, so I have…
-
RAID Log - Numbering
I have a column entitled 'RAID' with dropdown options: Risk, Action, Issue, Decision, and a column entitled 'Auto' which is a column type Auto Number starting at number 1 (no prefix or suffix). This Smartsheet has a form. When a user completes the form, they will select 1 of the 4 RAID drop downs, they submit the form and…
-
Project Plan Reports
Is it possible to have a report that pulls ONE task that is the oldest task (date-wise) that is not 100% for over 20 project plans? So this would be one report with 20 rows, all representing a different task that is the oldest incomplete task. Is this possible? If not, is there a formula that pulls the task name that I can…
-
Why isn't there a function to return the row number?
We have [column]@row. Why not =ROW()? I really need a column formula that returns the row number.
-
How to count total number of times a value appears in cells with multiple values.
I have been trying to find a formula to use that will let me count the total number of times a day appears in this column. I would like to ultimately put this info into a graph on the dashboard. Is there a way to do this? I have tried using the COUNTIF with CONTAIN and I haven't been able to figure it out while on a…
-
IF Statement that returns two values from two different columns
Good Morning Smartsheet Community, Currently working on a formula that will take the information from "15 single select columns" and condense this information into a single text column. I am trying to reproduce the column titles in my new column as text within the cells. Previous columns had a single selection for "1" if…
-
Looking to create a Auto Numbering System that is a little more advanced. [Help!]
Hey everyone! Looking to create a numbering system for Change order Generation for my company. Currently the Auto Numbering from smartsheet is a little simple for our uses. I'd like to come up with a formula that checks if any other change orders exsist for a given project number, then gives is a 1,2,3 after that. So the…
-
Formula on Project Plan
Hi, I have five stages on a project plan, parent row s, with numerous child tasks underneath. I want to have a formula that marks child tasks based on this formula: =IF([% Complete]@row = "1", "ITEM COMPLETE", IF([% Complete]@row = "0", "ITEM NOT STARTED", "ITEM IN PROCESS")) The parent rows also have this formula: =IF([%…