-
Formula Range
Hello Community, Is there a way to make the range for a formula start at a certain row and then continue on once other rows are created? I've found that leaving the end of range number blank or putting a future number row that has not been created causes the formula to be Unparseable.
-
Unique() or Distinct() function for finding unique values
Hi, It would be very helpful if Smartsheet redesigns the DISTINCT function so it can be used not just as an argument, but also at the top level to pull all unique values from a column. For example, if a column titled Customers has many duplicate names, we should be able to use a formula like:…
-
Matching Formula
Hello Community, I'm looking for a formula that will lookup and match a name with the same name from another sheet AND if there is a check box checked in a column on that row, it will automatically check the box on my new sheet. See my very simple example. I can give more context to what I'm trying to do if helpful. Thanks…
-
Multi Contact Column with Automations
Hi all, I have a multi choice contact column that has a simple formula that looks at a country column and based on the country returns multiple emails per country, so lets say that column country is France i have the contact column return three contacts, so far it's fine but it doesn't work when i try to use an automation…
-
Merged: Email Hyperlink in Sheets
This discussion has been merged.
-
Change formatting based on new date input
Background Currently, I am tracking whether a person attended a visit on a certain date and color coding for easy reference. Each row represents a person These dates are at regular intervals, so I'm using a column formula to calculate what the dates should with each each column referencing the column before it as long as…
-
Best method for linking 2 sets of data together that use forms to collate the information?
I'm working on a project to help devise a solution to track all of our organisation's skills & talent initiatives, plus that will provide us with some useful metrics. The plan is have 2 forms - part 1 that collates all of the schemes' information and then a part 2 that collates information on outputs, but which is sent…
-
Reverse the Ranking Order
I am working on ranking clients based on revenue with the highest revenue being number 1. In the end I want to build a top 25 list that could change on any given day based on new data. I used this formula to rank my items: =RANKEQ([Lost Client-SUM-BI Estimated Annual Revenue]@row, [Lost Client-SUM-BI Estimated Annual…
-
SUMIF and NOT Functions
I am working with three formulas to collect data in the Summary. I want to add the NOT Function to these formulas to exclude the rows that are starred in the CCC column. =SUMIF({Region}, "Philadelphia", {Contracted}) =SUMIF({Region}, "Philadelphia", {07/09/25}) =SUMIF({Region}, "Philadelphia", {Difference}) Thank you
-
COUNTIF Formula in Multiple Dropdown Box but Exclude a Word
I’m trying to create a COUNTIF from a multiple drop down column (referencing another sheet). Two words are similar: Active and Inactive. If I use CONTAINS, it counts both Active and Inactive: =COUNTIF({Certified Roster Range 1}, CONTAINS("Active", @cell)) If I use HAS, it counts when Active is the ONLY item listed in the…