Want to practice working with formulas directly in Smartsheet?
Check out the
Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Product questions?
Ask it here! The community's got your back.
Discussion List
Help w/multiple AND NOT ISBLANK date field formula
Hi team - I have 6 date column fields that are automatically formatted (record a date) when a Status field changes. Let's just call those columns: Date1 Date2 Date3 Date4 Date5 Date6 I created a check box "helper column" that I'd like to create a formula that looks across those fields to determine if ALL of them have a…
Help required on an Index Formula
I am trying to work out a formula that exists in a sheet created by somebody that is used for reporting although all of the data is corrupt. The formula is as follows: =INDEX({Malta SSOT Range 1}, $[Column45]@row, Market$1) Malta SSOT Range 1 is the source sheet and Column 45 is a column used in the sheet containing the…
Archive Records.
I am trying to automatically move records in my main collections sheet that have been validated for more than 45 days into an archive records sheet but this seems not to be working. I have attached a screenshot of the automation setup. I have also attached the formula from the main sheet as well.
Where to put JOIN to append data
Hello everyone, I have two sheets that I'm working on - the first sheet collates all information supplied by survey correspondents and the second sheet calculates to derive any information needed. First sheet: Second Sheet (expected output): I was able to compose a formula to get the proper count by cross-referencing the…
If Formula with Contact in Contact Column
Trying to build a formula that if X person is entered into "Project Manager" column, their corresponding team email contact will populate in the "Team Email" contact column. Both are contact columns. Here is what I have so far, I've tried with and without quotations: =IF([Project Manager]@row = Abby, Team 1, IF([Project…
Disable auto update of start dates for dependent tasks
Looks like there was a thread on this https://community.smartsheet.com/discussion/7262/forced-dates-when-dependency-is-enabled to disable auto-update of start dates when using the predecessor feature.. is this implemented?
Automatic population based on answers
Hi I am new to Smart Sheet and are having a problem trying to set up an automatic population. I have a cell with multi dropdown, based on what a person selects the answers for two other cells on the same rows are predetermined. If a meeting is X date then the date to confirm attendance is Y and agenda items are due Z date…
Create multi-contact cell from a row array of individual contacts
I have a sheet as: Header: SME1; SME2; SME3; All SMEs Row 1: Bill Ross; Suzie Collins; Anne Doe; =join([SME1:SME3]@row) Each of the SME columns is a contact. I want to fill my 'All SMEs' column with a formula which makes a multi-contact with all of the contacts joined together for easier filtering. I've tried to write the…
trying to add after the selection is completed
Using this formula to produce the table below: =COUNTIFS({Business Area}, $Label@row, {IT Sizing}, [Column2]$19) The data in the table is accurate, however I want the values in the table to be the hours needed to complete the tasks. The column name for the hours is called "Est Hours". If Business area is "Payroll" and "IT…
Match info from one column and alter the text to something different in another column
I need to take the info from a column in a sheet called Snow Specific Annual Revenue, and then alter the text slightly so that its easier to sort in order...I have tried many iterations of Match/Index, most recent is: =INDEX([Snow Specific Annual Revenue]:[Snow Specific Annual Revenue], MATCH([Snow Specific Annual…
Help Article Resources
Trending in Formulas and Functions