Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
Formula INDEX/COLLECT CLIENT VALUE by MONTHIn Formulas and Functions=INDEX(COLLECT({Sales Pipeline Range 1}, {Sales Pipeline Range 3}, @cell = [Account Name]@row, (SUMF{Sales Pipeline Range 6}, MONTH(@cell) = 1)) I want a formula that recognises on a referenced sheet a client name, and totals the value by …
-
Dates in IFS StatementIn Formulas and FunctionsI am trying to use dates (formatted in dates columns) in an IFS statement to compare dates in multiple columns and provide calculations based upon whether a date is before or after (<>) a certain date. I am getting an #UNPARSEABLE er…
-
Can i populate data referring to multi select drop down(as a primary key)?In Formulas and Functionsi have a column with multi select drop down option, i need to populate the data from another sheet referring to the drop downs select. How can i refer the first column as primary key to populate the rest of the data. My primary key would b…
-
Find first non-empty cellIn Formulas and FunctionsHi, What formula can I use in the Current Email Helper column to accomplish the below Desired Outcome. I'm not using a hierarchy so I cant use CHILDREN()/PARENT() functions. Here's the kind of logic I'm trying to follow: IF [Email]@row is…
-
Dashboard question- Can I add a list of locations to click on and all of the widgets update?In Formulas and FunctionsLike in excel pivot tables, how you can add a 'slicer' and then all of the pivot tables you've connected to it- will update their data based on the item you filter/click on.
-
COUNTIF of CHILDREN with HASIn Formulas and FunctionsI'm running into an issue with a formula that I'm trying to write that counts the results of a multi-dropdown column using the CHILDREN hierarchy. =COUNTIF(CHILDREN([Event Tier]165), HAS(@cell, "Tier 1: Off-Site Event")) I'm lo…
-
Nested MAX formulaIn Formulas and FunctionsIs there a way to use the MAX formula to look at a created column and check a box for the last entry of each day? I'm having no trouble getting the MAX to work for the full sheet, but it's not working for each day. I'm looking at the cre…
-
Column formula from a template not allowing me to editIn Formulas and FunctionsI downloaded a Smartsheet template and am now listed as the owner, however it is not allowing me to edit a column formula. The column isn't locked, but the formula is somehow.
-
SalesForce ConnectorIn Formulas and FunctionsI need to filter on multiple account id's in the connector. There is not an option to do this. Is there a work around?
-
(Count if) And & OrIn Formulas and FunctionsI need a formula that will count the number of rows with High priority and are New OR Open. I cannot figure this out, so any help is appreciated!
