Formulas and Functions
Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.
Discussion List
-
I need to collect the average of a column by referencing name in another columnIn Formulas and FunctionsI have columns in a sheet per the screen below. The Team Member is input through a form submission and can potentially be input many times. I am looking for a formula to collect the average score from all rows where one name appears withou…
-
Is there a way to automatically add two sheets data into one new sheets as parents and childrens rowIn Formulas and FunctionsHi, I was wondering is there a way to bring two smartsheets data into one automatically. Smartsheet A datas will be the parent row in Smartsheet C, and Smartsheet B will match the smartsheet A data and automatically added into Smartsheet C…
-
Counting a row if due date is >= 2 weeks from TODAY()In Formulas and FunctionsHi All I was wondering if anyone has been able to come up with a formula to count a row if the column due date is a certain amount of days from "today". I want to add a backlog tracker to my dashboard but I can't seem to come up …
-
Create a formula based on timeIn Formulas and FunctionsGood day...I am wondering if there is a formula that can bring back results based on time for example today()-created row brings back days...can I bring back hours or minutes?
-
Sheet Summary FormulaIn Formulas and FunctionsGood afternoon, Starting to try and better understand how to write formulas. I am trying to count the sum of the "BAE"column if my "Product Division" column has - Structural Shop Team - in it but it is coming back as #…
-
Report or formula to show time individual cell was changed?In Formulas and FunctionsWe would like to be to see when (timestamp) changes are made to individual cells in a row without having to manually check cell history for the cell(s) of interest. Is there a formula we can use to do so? Or is there a report we can export…
-
Return a Contact from another Sheet based on valueIn Formulas and FunctionsHello, I have a source sheet (Sheet A) that maintains a list of projects and assignments. I need a second request sheet (Sheet B) to intake requests. On this sheet, the project name will be included. I would like to use a formula to outp…
-
Conditional Formatting not working as expected.In Formulas and FunctionsHi, Excel: 2016 Version. I am creating conditional formatting dynamically from VBA with the below code every time when I opened my excel. The rules are getting created, but they are not highlighting the max and min value in a row (conditio…
-
Parent/Child Lines to be populated from FormIn Formulas and FunctionsI would like to create a form that allows for Parent information to be completed and populated and where applicable allow for child data to be entered and applied to that parent data. Example: Form User Enters Main Task and Description …
-
COUNTIFS Contains but Not ContainIn Formulas and FunctionsI have a multi-select column that contains both the options Pending and Pending Registration. I want to count if the Contract Status column contains Pending but not Registration. Here's what I have so far... need help. =COUNTIFS({Contra…