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.

Update to Is Not Blank Formula?
How do I make this formula operate the way I need to. If there isn't a due date or a status, I don't want it to get flagged as at risk yet. =IF(OR(Status@row = "Completed", [Due Date]@row = " "), 0, IF(AND(Status@row <> "Completed", [Due Date]@row - TODAY() <= 3, [Due Date]@row - TODAY() >= 0), 1, 0))
Formula Help: Risk Flag based on End Date
Can someone help me create a formula based on end date If EndDate is <TODAY and Status Does Not Equal "completed" Red Flag in Risk Column TIA
Multiple Deadline/Due Date columns for each project (row) - Combined Report
I have a sheet used to track grant deadlines, and there are multiple deadline columns for each grant (application deadline, report 1 deadline, report 2 deadline, etc. - example below). I am looking to create a report or even a sheet that pulls in a grant and each respective deadline that occurs in the next 120 days. My…
Display dates differently on a dashboard
I work in a global organization, and I prefer to plan my dates in 1/20/24 format but with our European partners that can get confusing. So when sharing dates with them we display as Jan 20, 24. However, I'm tracking and mapping dates against a lot of other North America teams who plan in 1/20/24 so it's easier for me to…
Sum the rest of a column
Hi All, I am trying to sum the rest of a column (see below). This is in the creation of a a blueprint workspace, so there is no data in there and so please ignore the divide by zero errors. I have 2 sections for project costs, one for labour costs which is based on a very simple salary*timeframe formula, and then a second…
If, then Formulas
Hi there! I am trying to create a formula for the following scenario and i've been unable to figure it out If Status Column is "Complete", Mark as Green, IF Status of Column is NOT Complete, then apply the formula =IF([End Date]@row < TODAY(5), "Red", IF([End Date]@row = TODAY(5), "Yellow", IF(AND([End Date]@row >…
Auto Save / Invalid Operations Error.
Hi All, I have been searching community forum to this unsaved issue that I am having with my PMO but no luck so far and appreciate if someone could help me with this. According to what I have observed, the tasks sheet is not getting saved due to which some of the columns on Portfolio / Project Tracking Dashboard (Schedule…
Symbols and Formulas
I am trying to create a formula that will give a column a symbol (red, green, yellow blue) based off of the amounts of colored symbols in the column. Right now in each row, I have associated a symbol based on the task status - the symbols are Red/Yellow/Green/Blue I want to be able to assign an overall Symbol for the…
#Unparseable - AVG if business unit and current year.
Hi all. In a sheet summary field I'm looking to get the average number of days, if the year is current and for a particular business unit. Iterations on the following result in #Unparseable of #Incorrect Argument? where am I going wrong? =AVERAGEIFS([Time in application (Days)]:[Time in application (Days)], [Date…
Process Identifier Automation
Hi, I have a formula that should be identifying the next number and adding a number to it based on the next number. What I am struggling with, it is repeating numbers and I cannot get it to stop. [Row ID] is an autonumber [Process Type] is a dropdown with PP - Parent Process SP - Sub-Process 3P - Third Party CA - Critical…

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

Check a Box if Between Dates on Another Sheet
Hey all, I am trying to build a formula to check off a box on my sheet if at least one date is found between two dates on a separate sheet. I've tried a million variations but here's what I have so far, thinking I was overcomplicating things =COUNTIFS({Approve Date}, >=[Week Starts]@row, {Approve Date}, <=[Week Ends]@row,…
How to Automatically Checkmark a Column for entries that are created within a time-based timeframe
I'm trying to write a formula that will automatically place a checkmark in a checkbox column titled "Today Entry" whenever entries meet the "Created" column criteria of being submitted after 1100 AM the day prior and 0800 AM today on a rolling basis: I've been trying to use the below column, but honestly I have no idea. I…
Calculating the total duration from a date & military time start and end
I have been looking at a lot of information on this site and this is the closest one I have found, however it does not calculate the minutes correctly. For example instead of 8hrs and 45 min it gives me 9hrs and -15min. Formula: =(([On-Site Date]@row - [Notification Date]@row) * 24) + VALUE(LEFT([Time of Crew arrival]@row,…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags