Formulas and Functions
Archives for March 2021
Discussion List
-
Calculating if one date is 14 days greater than another dateIn Formulas and FunctionsHello, 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.…
-
Nested formulas - conditional text concatenationIn Formulas and FunctionsI 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 Smar…Answered - Pending Review 74 views 1 comment 0 points Most recent by Mark Cronk Formulas and Functions
-
How do I populate a list of values from one column if a checkbox is selected in another column.In Formulas and FunctionsIdeally, 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 …
-
Is there a way that I can have a form populate two different rows in my sheet?In Formulas and FunctionsI 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 a…Answered - Pending Review 14 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
If parent card is dragged to later row in roadmap, then children cell value changes.In Formulas and FunctionsHi 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-…
-
Formulas Including Today as Calculation with Blank ValuesIn Formulas and FunctionsHello. 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 we…
-
Formula needed: Multi drop down select column to output value in another columnIn Formulas and FunctionsHi 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 tact…Answered - Pending Review 37 views 10 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
COUNTIF FORMULA (3 Columns, 1 Column includes contact)In Formulas and FunctionsHi 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 t…Answered - Pending Review 25 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Formula to update a value automaticallyIn Formulas and FunctionsI 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, R…
-
NETDAYS #INVALID DATE TYPEIn Formulas and FunctionsI 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?…