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.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

I need a formula to create a Contract iD for 4 different org's that are listed in 1 column
I need to create a formula in a column that will in the end give me something like ATF021 or RDI231 or RD473 Each org, ATF, RDI and RD will have their own contract iD; so ATF021's next line item needs to be ATF022, 023. Then if the RDI org enters a line item, there contract iD will be RDI231, RDI232, RDI233 and so on. Same…
What formula to use to automatically enter today's date on column x, when column y is filled
How do I get a cell to display the value of the last cell in a column excluding one of the values?
Hi All, I have a column in a project plan with a droplist of certain values. I want to display the value of the last cell in the column that has any value except Not Started. Would someone please provide a suggestion?
Replacing NULL in a column with zero
I need a formula(s) to use that can replace "NULLS" in a worksheet with zero or replace nulls with "Blank". One column contains text values and the other column number values A formula to replace "NULLS" with zero in a number value column Another formula to replace "NULLS" in a text value column with "Blank"
Thanksgiving Dinner
I have a colleague looking to demonstrate the power of Smartsheet for project management and task management. She is trying to create an example of the task management and predecessor functionality using a typical American Thanksgiving dinner. The issue is Start and end date are only able to be calculated in days from what…
Seeing #UNPARSEABLE issue when applying formulae in the summary
Here is the formula I have =COUNTIFS([Level]: [Level], 1, [Status]: [Status], NOT(OR([Status]@cell= "Not Applicable", [Status]@cell= "Canceled")))-COUNTIFS([Level]; [Level], 1, [ECO Workflow]: [ECO Workflow], "ECO Implementation", [Status]: [Status], "Completed") I have cross checked spellings and quotations, could any…
Alert if someone hasn't Posted
Trying to use the Forms to do a Daily Log of what people are working on with in there roles. al the Info just goes to a Big Splash sheet right now. but i am trying to think of a way to get an alert if people are not Filling this out. is there a way to set a work flow Alert someone if people are not filling this out? if i…
How do I pull the second name from a multiple-contact column?
In Smartsheet I have a contact column (Project Support) that can have up to three contacts (first name + last name), for example Jane Doe. I then have three other columns that pull the first contact, the second contact and the third contact. The first contact column is Project Support 1 and the formula is =LEFT([Project…
Calculating SUM of Duration
I have a Smartsheet (Sheet A) that I use to track projects assigned to each employee and the duration of that project (a Start Date, End Date, and a Duration column with a formula that shows the individual duration for a specific task). I have a separate Smartsheet (Sheet B) that I use for reporting purposes that looks at…
Help with COUNTIFS Formula w/ multiple possible criteria in the same column
I am looking to create a formula that can count a couple of items and if any of 3 possible solutions are in play. Any help that anyone can lend would be appreciated. Items I am looking to count: 'Carrier Initiated TDM' is checked and the status is 'In Progress' and if the Scope/Decision/Solution is any of these 3 possible…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Using JOIN/COLLECT and an OR?
I'm trying to write a formula using the JOIN and COLLECT options. However, I've hit a sticky point when I want to include an OR criterion on the COLLECT portion. My current formula (which works perfectly) is: =JOIN(COLLECT({Assets Range 1}, {Assets Range 2}, [Tool]@row, {Assets Range 3}, "Live"), ", ") However, I want to…
INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…
Parent Color Symbol, Based on "Average" of Child Symbols
Okay, here I am again! On the Project I am working on, the Stakeholder wants parent rows for no reason other than to be able to expand and collapse the data. I nicely suggested that since the data would only be for 1 year (broken down in quarters and about 5 users listed each quarter), that since the data was not excessive…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags