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
-
Looking to set Notifications/Reminders beyond the default optionsIn Formulas and FunctionsHello - I'm a bit new to Smartsheet but loving it so far. I have a few columns with dates that I would like email notifications or reminders set up when the following conditions occur: 1 year anniversary from date in cell 5 years, 9 mon…
-
Tire Maintenance - Form / Spreadsheet AssistanceIn Formulas and FunctionsHello All, Today is my first day (YAY!). I'm digging Smartsheet thus far, although, I'm looking for suggestions. I've been tasked with creating a Tire Maintenance Program. So far I've put the basic asset information (Year, Make, Model, VI…
-
Revising duration so it doesn't count first dayIn Formulas and FunctionsI want the range of days from Monday the 1st to Monday the 21st to read 21 days; yet it reads "22 days" in the duration column. This is because day 1 is the first day, when I need "day 1" to be the following date from …
-
Combine IF formulas in one cellIn Formulas and FunctionsHello, I'm trying to create a %Complete column based on a drop down list column called "Status". For example, I'm looking to combine these formulas into one cell, then copy and paste to all other cells in the same column. I'm …
-
Criteria for Alerts and Actions RuleIn Formulas and FunctionsMy boss has a Smartsheet set up to send a Update Request 30 days before today. For example row 7 would look like ....=[Due_Date]7 - TODAY() Would this alert still be sent if Smartsheet was down for maintenance at the scheduled time the a…
-
Formula HelpIn Formulas and FunctionsHello New user needing help with formula. I would like it to be something like this: When the due date is => than today -1 turn red, if the due date is < today - 3 days turn yellow, if due date is is =. than today +5 turn green T…
-
Column Status FormulaIn Formulas and FunctionsHi Everyone, I have a status column with the following options: Not Started, In-progress, Complete, N/A. I've created a formula if the parent row is set at 'Not Started' then the sub-task would automatically change to 'Not Started'. Sa…
-
Parent Sum IFIn Formulas and FunctionsI've tried a variety of calculations, and can't seem to get the results I'm seeking. I'm simply trying to add up all of the parent rows in a column called Resource Days that are Assigned To a specific team member. Any suggestions? =SUMI…
-
Enhancement Request: Report Criteria What? on Dropdown column like Text/NumberIn Formulas and FunctionsWhen I have a Dropdown column for the What? criteria of a Report, my only option is some version of the "is one of" criteria. What I want is to be able to build the criteria like a Text/Number column, for example using "con…
-
Count & AVG only if another column contains "text"In Formulas and FunctionsHi Again, After scouring discussion boards I have managed to Average the total of the rows, see below =IF((COUNT([Days to respond]194:[Days to respond]214)) = (COUNTIF([Days to respond]194:[Days to respond]214, 0)), 0, SUM([Days to respo…
