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.

How to change the title of a sheet in the report calendar view?
I have a report set to calendar view with numerous sheets feeding it and due dates tied to them. The title for the bubble that shows up on the calendar view defaults to the name of the sheet. I want to be able to change the title to a cell within the sheet, is this possible?
CountIfs Question
Hi all, I have a formula where I am essentially counting the number of responses by specific criteria. I have it working with the exception of when multiple values are selected from the drop down. I have posted photos below. I am trying to have it count for all of the areas of concern. For example, the Challenger would…
Determination of Request Type based on form answers
Hello all, my org handles a few types of requests that are broken out based on need and qualifications. I am attempting an integrated request form that will remove the need for multiple form types. I am wanting a column [RequestType] formula to come up with results based on the answers in the form. One thing that may…
Count of rows created on 2 sheets within a certain time frame.
Hi everyone! I would like to get the count of rows created on 2 sheets within a certain time frame. I created a formula (1) to get the count of one sheet and it worked. I tried to add the other sheet to the formula (2) but I got an error message (3). =COUNTIFS({Created 2}, IFERROR(MONTH(@cell), 0) = 5, {Created 2},…
Subtract 2 Months from "6 Month Renewal Reminder" Date Column
Hello, What formula reliably returns a date 2 months before the date in the "6 Month Renewal Reminder" date column? This is the last formula I tried, which I found in another article here in the Smartsheet Community. =IF(MONTH([Date Column]@row) - [Number of months before]@row <= 0, DATE(YEAR([Date Column]@row) - 1, 12 +…
I need to add days to a date with a formula.
I use the formula: =Procedure8+35 and it will calculate 35 days from procedure with the correct date. If I ask it for +76 days I will get #INVALID COLUMN VALUE. Not sure what I am missing. Procedure is the column and 8 is the row where the date is calculated from.
#INVALID VALUE from =INDEX formula
I have this formula, that works in other sheets that I have, however in this one it returns the #INVALID VALUE error. Help? =INDEX([Current Task]3:[Weekly Status Notes]86, MATCH(true, [Current Task]3:[Current Task]86, 22)
Project Status to Update a Sheet Summary Status - Formula?
Is there a way to have a formula in a row or in the sheet summary that does the following: When a row is added in one sheet and the project status is Completed, then within the project itself in Sheet Summary change the status to Completed as well? I am not sure if it is possible as one status in one sheet would have to…
formula to sum specific dollar amounts based on other columns
I have a sheet where I log all the purchases I make; I purchase for multiple groups and those funds come out of different budgets. I list what budget I purchase it against on each line and I want to have a graph that updates automatically on my dashboard for the different budgets and how much of it I have consumed. so, I…
Sheet Reference Manager
When I use the Sheet Reference Manager, I am unable to use the "Search List" and the formatting to edit the references is off. Is there a fix for this?

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