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 DropdownIn Formulas and FunctionsHello, 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…
-
Why am I getting an #Incorrect Argument Set when all I have done is change the Reference table?In Formulas and FunctionsI 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…
-
count valuesIn Formulas and FunctionsHI, 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 …
-
COUNTIF, Cross Sheet, Multiple ContactsIn Formulas and FunctionsI 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 …
-
How to count contacts or email address in contact columnIn Formulas and FunctionsHey 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…
-
Name to Email with exceptionIn Formulas and FunctionsHello, 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…
-
Combine multiple lines from one smartsheet to a secondIn Formulas and FunctionsWe 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.
-
Formulas in Contacts ColumnsIn Formulas and FunctionsI 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…
-
vlookup value 1 is invoice then Credit otherwise Debit from other sheetIn Formulas and FunctionsHi, 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;…
-
Formula INDEX/COLLECT CLIENT VALUE by MONTHIn 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 …
