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.

Parent RYG(B) status balls automated based on Child status
Hello, I have been scanning the community and have found some bits for what I am trying to do but am struggling to put it altogether and was wondering if anyone could help? I have a list of tasks with headers (parents) which then have sub tasks (children) and some of them also have sub tasks (children again i believe). The…
Percentages
Is it possible to have .5% as a percentage. Whenever I put .05 it rounds to 1% and .04 rounds to 0%. Thank you
Adding together multiple COUNTIFS?
Hey everyone. I'm trying to implement a formula that will allow me to reference two ranges from one sheet and follow the specified criteria that is given to them. My most recent attempt; =COUNTIFS({Unit_Type}, "CP2 - Double", {ACCS Overall}, [T2]26) + COUNTIFS({Unit_Type}, "CP4 - Double", {ACCS Overall}, [T2]26) +…
Remaining Budget
Good evening: I have broken down my Project Budget and spent a total of 13% of my Budget. I have used the formula to get the total sum (13%). However, I am challenged with adding to the formula to get the remaining budget of 87%. Sum Formula: =SUM(CHILDREN()) Task A: 10% Task B: 1% Task C: 2% Task D: 0% Thanks for the help…
Displaying a date in a non-date column
I am trying to display the earliest date in the "Start" column and the latest date in the "Finish" column, thereby getting the start and end dates of the whole project. I can get these, and display them in a third column formatted as a "date" column. Now, I want to include this text (the date) in a forth column formatted…
Working with Time Values in Cells
Hi all, perhaps someone can help me with a workaround. I have a sheet that captures time values in a column. As far as I know, Smartsheet doesn't recognize time or have any formulas more granular than "Date" formulas. My question is, does anyone know a way to convert time values into numeric values? For example, if the…
Automate % dependant if cell is blank or has a date
Hi, i am looking for some help please. I have a % complete column that i want to automate to 100% if a date in another column has a date in, but also return 0% if the date column is blank. I feel this should be easy but am struggling and would appreciate any help. Thank you as always Dave
Formula irregularity
Fairly new to Smartsheet, although I know my way around an Excel spreadsheet. I am trying to create a count of how many reports are submitted per hour on each given day. The reports come in via a Web Form, into the Taxi Rank Data sheet. I have created the following Sheet (see attached jpg) with the following formula,…
Formula to automatically check a box when a certain cell is populated
I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has information in it due to the update request being filled, I would like a certain box to be…
Two different triggers for one check box
Hello, I find this community very helpful in the search function, but I haven't participated much with my own questions. I'm hoping you can help. I have one check box that I would like to be triggered in two different situations "this OR that" kind of question. I have it programmed for one parameter, but I don't know how…

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

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"
Form: Require "Need order by" field to be AFTER today.
We have a form that has a DATE field called "Need Order By" so that the user can tell us the date the the order must be fulfilled by. Can you guess what date users MOST OFTEN use? Yeah, you got it! a date in the PAST. We are very anxious to find a way to force the user to input a date that is in the FUTURE. Can anyone tell…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags