Formulas and Functions

Archives for March 2021

Calculating if one date is 14 days greater than another date
Hello, I need to calculate a flag if the construction end date (in a cell) is greater than 14 days from the construction start date (in a cell). If the result is greater than 14 days the row will be flagged. I don't even know how to start. Any help would be appreciated.
Nested formulas - conditional text concatenation
I want to set up a column in which all components of a name are concatenated. However, I don't want to include the "middle initial" field if it's blank. I've achieved this in Excel, but can't seem to find the right method in Smartsheet. A screenshot of my method in Excel: In Smartsheet I've tried a number of variations,…
How do I populate a list of values from one column if a checkbox is selected in another column.
Ideally, I would like to populate all of the values in column 2 into one cell if the checkbox is selected in column 1. I would like each title to be on it's own line in the cell. For instance, The cell should look like this: Adjusting to Remote Work Life Admissions Processing & Review Advanced Capture (AnyDoc):…
Is there a way that I can have a form populate two different rows in my sheet?
I have a sheet that I am using to track some events that I am running and I have created a form to allow people to request support for additional events. Sometimes these people will have two different events that they will need help with and instead of making them fill out multiple forms can just one form populate multiple…
If parent card is dragged to later row in roadmap, then children cell value changes.
Hi All. This is very similar to the thread that @Paul Newcome answered on children rows populating / changing a parent row here: https://community.smartsheet.com/discussion/13326/formula-to-update-status-on-a-parent-row-based-on-any-child-row However, my situation is opposite. My ask: if I drag a parent card to a further…
Formulas Including Today as Calculation with Blank Values
Hello. I'm trying to use the Today function to help calculate a check column. Essentially, I want to compare a Due Date Column and a Completed Date column to return a value in the Two Weeks column. If Due Date is within the next two weeks of Today AND the Completed column is blank, it should return a value of "1" in the…
Formula needed: Multi drop down select column to output value in another column
Hi All, Any help with a formula? This is driving me nuts! Basically what we're hoping is to be able to select multiple values within the "Rate_Card_Tactic_T4/T5 column", and output the dollar amount that is assigned to that tactic in "T4/T5 Cost - Email Blast" column. This is as far as I've gotten... it works only if I…
COUNTIF FORMULA (3 Columns, 1 Column includes contact)
Hi All, Need help with a formula! I need a formula to summarize the following criteria. If Project Track = XX, and if Project Phase = XX and if Project Manager = X Person" what is the output? My current formula, but it doesn't seem to be working. Is it due to the fact that the Project Manager filed is set to contact list?…
Formula to update a value automatically
I have 5 rows. The value for each can be low, medium, or high. If the majority of the rows is one of the values then I want row 6 to return that value. But if any of the rows are high Row 6 value should be high. Example: Row1--Medium, Row2--High, Row3--Medium, Row4--Low, Row5--Low., Since Row2 is High Row 6 value is High…
NETDAYS #INVALID DATE TYPE
I am trying to get days between 2 dates with the following formula. =NETDAYS([End date]3, [CR1 - Fabric yardage]3) One of the dates came from another sheet, with formula. If I type a date on top, the formula works fine. How could I fix it? Thanks!!

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula Help
Hello, Last formula I need to figure out to finish this template. @Kelly Moore You have been so incredibly helpful, if you are able to help me on this last one I owe you one! I know I have an error in the formula or maybe using the wrong one. I am trying to pull the Start Date and End Date on the current sheet, taking into…
Need to calculate a date based on data in another sheet
I'm creating what is basically a notification system that's too complicated for just Automations. In a one sheet I've set up a Cadence by a Category. So the category might be Webinar. The cadence is captured in multiple columns labeled First Push, Second Push, etc. Each of those houses a number representing the number of…
Display Issue with Formula
I have another equation that is not displaying the value I need to pull down. I think I have the formula right, it's not coming back with an error, yet there is no numbers displaying. Ultimately I want it to pull down the generation from a previous year so wer can compare. Ideas/ Thoughts?

Formulas and Functions

Discussion List

Help Article Resources