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

  • Counting Content of a Multi-select Dropdown
    In Formulas and Functions
    Hello, I have an issue that was more than me and I am seeking help. I have this column, which contains information about the "Calendar week number" during which an event occurred, as you can see in the first screenshot. An impor…
    5 0
    5 views 0 comments Started by PaolaHep
  • Why am I getting an #Incorrect Argument Set when all I have done is change the Reference table?
    In Formulas and Functions
    I have a sheet that I am using as a master VLOOKUP table. I needed to duplicate the sheet so I can make updates for an upcoming project and not break my ongoing project using the current sheet. I created a copy of the original sheet and ch…
    Accepted
    4 1
    Accepted Answer 4 views 1 comment Most recent by Robert Tebault
  • count values
    In Formulas and Functions
    HI, I have a form with checklist info for different types(Type 1 , Type 2), also in the form i specified minimum nr of selection for each types. After submission i want to check whether submitted info has the valid nr of selection r not …
    PYI Profile Photo PYI
    Unresolved
    13 1
    Question 13 views 1 comment Most recent by PYI
  • COUNTIF, Cross Sheet, Multiple Contacts
    In Formulas and Functions
    I am counting the number of times a contact is referenced in the Assigned column, cross sheet. There can be multiple contacts listed on each row but I am just looking for a total count of the number of times an individual is listed. This …
    Unanswered
    10 0
    Question 10 views 0 comments Started by Jessica Griffin
  • How to count contacts or email address in contact column
    In Formulas and Functions
    Hey folks - I created a column that is a contact list. In that column there are full email addresses or the Smartsheet contact: Question - how do I create a summary formula that counts either of these and gives me a full count for the num…
    jmo Profile Photo jmo
    Accepted
    110 12
    Accepted Answer 110 views 12 comments Most recent by Jessica Griffin
  • Name to Email with exception
    In Formulas and Functions
    Hello, I have a function that turns a cell with a name into an email address for supervisors. However, some supervisors are in training and have an abbreviation at the end of their name, is there a way to come to the same email result? T…
    Unanswered
    5 0
    Question 5 views 0 comments Started by Desertbird
  • Combine multiple lines from one smartsheet to a second
    In Formulas and Functions
    We are looking for a way to keep our on call schedule updated and I am stumped on a potential formula. Any ideas are greatly appreciated.
    Unanswered
    4 0
    Question 4 views 0 comments Started by Rebecca Menning
  • Formulas in Contacts Columns
    In Formulas and Functions
    I have researched this issue through multiple earlier discussions, but I can't find a permanent or reliable solution. I am trying to use formulas to populate contacts through multiple stages of a workflow- currently 2 sheets- and cannot re…
    Answered - Pending Review
    20 4
    Answered - Pending Review 20 views 4 comments Most recent by AFlint
  • vlookup value 1 is invoice then Credit otherwise Debit from other sheet
    In Formulas and Functions
    Hi, I have 2 sheets. sheet 1 = field "INV/CN" = INVOICE or CREDIT NOTE field "ICO Number" unique number in sheet 2 I have these 2 query's cell Debit / Credit => =VLOOKUP([ICO Number]@row; {ICO Header Range 1}; 2;…
    Answered - Pending Review
    15 2
    Answered - Pending Review 15 views 2 comments Most recent by jan aelbrecht
  • Formula INDEX/COLLECT CLIENT VALUE by MONTH
    In Formulas and Functions
    =INDEX(COLLECT({Sales Pipeline Range 1}, {Sales Pipeline Range 3}, @cell = [Account Name]@row, (SUMF{Sales Pipeline Range 6}, MONTH(@cell) = 1)) I want a formula that recognises on a referenced sheet a client name, and totals the value by …
    Unanswered
    11 0
    Question 11 views 0 comments Started by Michelle Maas