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.

Imported Formulas from Excel
Happy Wednesday! I have been going in circles trying to figure out where this formula is going unparseable. I researched it against other similar (working) formulas in smartsheet and the Formula errors guidance- but I am still missing it- hoping a fresh set of eyes can help me pick out the culprit. Thank you!…
Using today() in formulas
I have a smartsheet that has some values calculated using a formula containing today(). Everything works fine on my dashboard when I use this, but I have found the dashboard becomes stall unless I open the smartsheet up to let the today() function update with the current date. Is there a way to use this so that it will…
Look up and sum costs of selected features
I am building a form and associated sheet/workflows to track requests for vehicles from our customers. I'm hoping to find a formula that would allow me to use features chosen in multi-select columns to look at a different sheet where the costs of each feature are organized, and return the total cost of all the features…
Recurring Dates on a Calendar
I am working on a team calendar that includes each team members flex day that might fall every other Tuesday and every other Friday. I found this amazing formula for the next Monday, but I would like to incorporate a condition for if the week is even or odd For example, if the WEEKNUMBER is even, then pull the next…
Obtain total amount of days to close a claim (SmartSheets)
I would like to be able to find out how many days it has taken to close a claim. I cannot figure out the formula to do this. Is there a formula that I may use to cop and paste all the way down my rows? Each column are calendar dates. Date of Loss Date Closed Total days 01/20/2020 8/30/2020 = Can someone please help?
Run reports based off of certain cells without tying it to specific data
Hey all, So I am trying to pull historical data off of weekly back ups. Specifically I am trying to pull project health (color ball symbols) off the last 8 weeks and display them on a dashboard horizontally broken out by columns of each week. I tried cell linking them to the top 8 rows and it works until a new back up is…
Is there a way to assign a certain task/activity to multiple groups and generate report by group?
I want to use Smartsheet to track progress of task/activity by team or people. However, some tasks/activities may be assigned to multiple teams or people. For example, activity A to be done by x & y. Activity B to be done by y. Then, I want to create a report/dashboard to show all activities assigned to y (activity A & B),…
Updating Fields Based on Input
I have a form in which I let people enter in either a Monthly Budget or Total Budget. If it's Monthly, each Monthly Budget field obviously gets filled in with a value, but if it's a Total Budget, those Monthly Budget Fields are left Blank. Q: I know how to allocate the Budget for each month, but is there anyway to populate…
How to use Form response to retrieve the right template?
I have 7 templates for client renewal. I want to create a workflow either with a form or formulas, the user will select the right template for the client renewal and automatically added to the Master Client Renewal Project Plan. Example 1 - Client Renewal - Template A Example 2 - Client Renewal - Template B Example 3 -…
IF Function (related to dates)
Hi @ all, I have a formula issue where I would like to get your help. As you can see I have a delivery cell which I would like to link to my "Financial Year" cell based on the following condition: FY2020 = starting 01.01.2020 until 31.12.2020 FY2021 = starting 01.01.2021 until 31.12.2021 FY2022 =starting 01.01.2022 until…

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