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.

Creating a Formula for Dates and Traffic Lights
Hi, all! Our office is new to the SmartSheet community. I am having some trouble creating a formula for a sheet. I have the following columns: * "Initial Contact" - formatted as a date * "30 Days Since Contact" - formatted as a green traffic light * "60 Days Since Contact" - formatted as a yellow traffic light * "90 Days…
Can I create a hyperlink by combining text strings and fielded data? Pretty basic parameter work
I have fields: email: subject: body: I want to use this hyperlink to open an email with those parameters: <a href="mailto:myemail@email.com?subject=This is a subject. You can't use certain characters in here. But we should be able to control that.!&body=Here is the body. Same problem with special characters.">Link to send…
Formula to change line item to 'at risk' when due date is passed
Goal: When a finish date is passed on a line item, I want the status column to change to 'at risk'.
I would like to count the aging but I'm getting #UNPARSEABLE in this formula.
ISBLANK or 0 (ZERO) : Formula for a column
Good afternoon, I have the following formula that is populating my "HRS Left" column =IF(OR(ISBLANK(BAC@row), ISBLANK(HTD@row)), BAE@row, SUM(BAC@row - HTD@row)). But I need to be able to write the formula so that the "HRS Left" column will populate if my "HTD" or "BAC" column is "0" (zero) or ISBLANK Thank you
Generating a column value until another column is filled in
Good afternoon, I am looking to see if there is even a formula for what we are looking to do. We have an "HRS Left" column that projects the hours left on a scope item with this formula =SUM(BAC@row - HTD@row) However!, until we actually start working on that scope we have a "BAE"column that carries our Budget At Estimate…
Formula for Status
I would like to auto create a status based on an end date, completed date, cancelled checkbox or on hold checkbox. If end date is in the future an neither checkbox is selected then "Open". If the end date is in the past then "Overdue". If complete date has been entered then "Complete". If cancelled checked then…
Unparseable Error
Dear Smartsheet Community, Very new to Smartsheet and having trouble with 2 formulas that work in Excel. =IF([Date Approved] = 0, [Date Calculation],"Completed") =NOW() - [Date of Submission] Could you kindly let me know if the formula structure is incorrectly done? Would appreciate your input. Thank you. Best, ~ Rowenna
Automate Risk Flag
Hi All, I am struggling with trying to find and create a formula to automate the Risk Flag. I'd like to use simple logic to provide a flag if any of the ancestor rows have one of the following values The two columns are Status, with dropdowns, and Risk Level with High, Medium, Low Symbols, and I would like to return a red…
Hi, can anyone help me to get my Green/Yellow/Red/Blue Status to work correctly?
I have to write a green/yellow/red/blue status indicator with a risk override field as well. The concept is that if the Risk Override field is populated then that should be the status. The risk override field will be a drop down between Red and Yellow. If that is not populated, then it should be Blue if % complete is 1…

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

Issues with Numbering Children (Child 1, Child 2, etc.)
Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following: Create an auxiliary column with a "1"…
Netdays calculation with optionnal date column
Hi i'm looking for a formula to calculate the netdays between 2 dates. but i have 3 dates in the equation. a date column (date 1) whit references from another sheet and a manual one (date 2) to overwrite the first one. the third date is the "today" date (date 3). so i'm looking for something like: netdays between date 1…
Formula to count in progress child tasks using % complete
Hello, I am trying to obtain the count for in progress tasks using my % complete column and excluding parent rows. The criteria I want to use: Count if Children = 0 (no parent rows) If % complete <1 and >0 I have the formula working for one value: if % complete <1. But I'm stuck on trying to get the formula to work with…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags