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
-
How to pull rows from a different sheet only if they're marked as "in progress" ?In Formulas and FunctionsHi there, I'm looking for a way to pull rows from another sheet if they are marked as "in progress" (or any other status that's not "complete"). Ideally, I'd want to pull everything from that row and not just a single c…
-
Reference an entire column and sync it with another column in a secodn sheetIn Formulas and FunctionsLooking to take all 150 rows from a column in sheet 1 and sync them to sheet 2. Any changes to sheet 1 should be reflected in sheet 2.
-
If i check this checkbox, then check another check boxIn Formulas and FunctionsI am looking for a formula that says... if i check this box on this sheet then go check another box on another sheet. What am i missing to make the 2nd box get checked when Purchased @ row 1 is checked? =IF([email protected] = 1, {other shee…
-
Sumifs formula help pleaseIn Formulas and FunctionsTrying to determine # of total hours if a specific program is listed. Seems simple but keep getting errors. Attempts below. Any thoughts? =SUMIFS({Team Range 9}, >0, ({Team Range 8}, FIND("Program", @cell) =true)) =SUMIFS…
-
If Formula that Autopopulates namesIn Formulas and FunctionsHi! I need help with a formula that would do the following...... If John Smith was a Client Services Director that was assigned to two states (AL and LA), which formula would I use to populate his name into the column adjacent to the stat…
-
Branding Update RequestsIn Formulas and FunctionsCan I add my logo to the update request so that they look similar to the automated alerts?
-
IF-WORKDAYS CalculationIn Formulas and FunctionsI have a sheet with a [Request Submitted] column. Our SLA to attend to any received request is 2 business days. So I'd like to add a column that highlights any overdue items. My logic is: If TODAY is 2 business days past [Request Submit…
-
Select a Value in Dropdown Cell Using IF FormulaIn Formulas and FunctionsI want the LabWare User Status cell value to be Pending if the checkbox in the Request LabWare Account cell is Checked. I've tried IF ([Request LabWare Account]@row = "Checked", "Pending") and a few other formula variat…
-
How to extract an end date from a text string in a cell with a date range?In Formulas and FunctionsHello, I am trying to extract an end date from a text string into a separate date cell in a separate date column. For example, in a cell with the following text string "1/1/14-6/30/22; 10,000,000 print and secure electronic" I wo…
-
Numbers won’t add up on construction template?In Formulas and FunctionsIt has to be easy? Or the way I copied and pasted? It’s the template for construction estimate? Some of my numbers won’t total-and the very top number for total for entire estimate won’t populate?
