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
-
Two new PPM Functions: Successors and isCritical, available now!In Formulas and FunctionsHi Community, We’re excited to announce the launch of two new PPM formula functions available now in Smartsheet: Successors and isCritical. The Successors function (type: numeric) allows users to calculate the direct successors of a task…
-
Date formatIn Formulas and FunctionsHi, Could you make it possible to edit the date format as you can in excel or add this date format DD.MM.YYYY?
-
Drop down list from another sheetIn Formulas and FunctionsI currently have two sheets. Sheet1: Company List, Sheet2: Contacts. I am trying to create a dropdown column listing the companies from Sheet1 to populate the drop down for a column in Sheet2. This would essentially work as a lookup to …
-
COUNT with Distinct with multiple criteriaIn Formulas and FunctionsI am trying to create a count when 2 different criteria, when combined, are unique. Here is some sample data: I am trying to count late bills (checkbox) only when the customer number and bill date combined are unique In a summary field, I …
-
Formula to show the number of items that meet 2 criteriaIn Formulas and FunctionsI am looking to tally up the number of tasks that meet the following criteria: Don't have a check in the column "Done" Have a due date within the next 14 days I am actually going to create 3 buckets (due within the next 14 days f…
-
It there a formula to use so that I can calculate an amount between dates?In Formulas and FunctionsHi! I am trying to calculate the amount outstanding between certain dates, but I can't figure out what to use or if that is even possible.
-
Status If/And FormulasIn Formulas and FunctionsI have a project manage sheet I'm managing that I can't seem to get the formulas right in. The first one has two parts. 1) I want the status to be green if the Planned Completion Date is equal to today or the future. The Status to be Yel…
-
Formula for Max Value and Row NameIn Formulas and FunctionsHello - I am trying to pull in the max value of column A and the name(s) associated with that value. I am trying to use the following formula to pull in the max value and taking into consideration there could be multiples of the max value…
-
countifs from a multi-select to count two itemsIn Formulas and FunctionsI have a multi-select field with 3 items (ex: A, B, C). I want to be able to get a count for 1) cells with A and B and 2) cells with all (a, b, c). Running into trouble. I've tried: =COUNTIFS({acct type}, "Signed Account", {Pro…
-
What is wrong with my formula?!?In Formulas and FunctionsHi all I am using the following formula to tell me if a certain selection is made and another entry is greater than or equal to 12, but for some reason it is still flagging as Yes even when the cell is less than 12. What am I doing wrong?…
-
Combining IF statementsIn Formulas and FunctionsHi Smartsheet community, I am currently trying to create a formula, that states if Updated Completed Date is blank then use the date in Original Completion Date column but if not blank then use the date in the Updated Completed Date column…
