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
-
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…
-
End User decision making on which smartsheet to updateIn Formulas and FunctionsHello, I am relatively new to Smartsheet but finding the functionality robust. I am looking for a way to create a workflow that will direct end users to the appropriate Smartsheet Example: Are you requesting an update at the Doctor leve…
-
Is there a formula for checking a box if date in another column is changed?In Formulas and FunctionsI have a checkbox column that I've set up a "Change Cell Value" automation to check the box when the date in another column (Due Date column) is changed. However, I would like the box to be checked only if the change in date is g…
-
Forms that need to incorporate multiple line entriesIn Formulas and FunctionsWe currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is fi…
-
Formula to find latest/most currentIn Formulas and FunctionsHey friends! I have two sheets. I need one to behave as a "log" (columns: Machine SN (Primary), Machine Hours, Machine Status (Dropdown List), Current Machine Location). This log will be populated by Forms. The second, separate…
-
Formula to only show characters before a specific character in a cell?In Formulas and FunctionsHey friends, Needing some help creating a helper column. In column from imported report I get, "Asphalt Distributor (45)" where the "45" represents the quantity of assets in that category. I need to create a helper c…
-
Adding # of days with in a date rangeIn Formulas and Functionsthis is what i came up with looking at other people i keep getting #invalid operation =SUMIFS({2021 Sioux City Utility OSHA 300 Form Range 18}, {2021 Sioux City Utility OSHA 300 Form Range 1} <= DATE(2021, 1, 31), {2021 Sioux City Util…
-
Gantt View Settings Start Date Column SelectionIn Formulas and FunctionsWhile in the settings for my Gantt View my "Start Date Column" drop down selections does not include the column I want to use. It was there before. What could have happened. It is formatted as a Date. Also baselines keeps bein…
-
Highlighting duplicate data based on two conditionsIn Formulas and FunctionsHi, I want to make a formula to highlight whenever to cells contain the same data on the same date. I'm working with a marketing calendar and want to find a way to highlight whenever two campaigns are planned to go out to the same country…
-
Alphanumeric number parse to just the alphaIn Formulas and FunctionsI have a column with an alphanumeric number "CYG2525" or it could be "C2525", "GY2525". As you can see the alpha can range in the amount. I need to be able to pull over just the letters so "CYG" o…
