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.
Discussion List
Formula cell limit
Help! I hit the 25000 cell limit when doing formulas .is there a work around or a way to get limit lifted with business license?
Finding the closest date today with 2 columns of dates
Hi, I am working on a formula to show the next date from 2 rows of dates. I tried =MAX(COLLECT([Release]:[Release], [Live]:[Live], >TODAY())) - and it showed a date from the past. I tried =MIN(COLLECT([Release]:[Release ], [Live]:[Live], >TODAY())) With the same results. Any help is much appreciated.
Need help with tracking time
I am barely new to Smartsheet but I can see the potential of helping me with my job duties, I work as a service dispatcher, We have been running out of Microsoft spreadsheets but I don't know a lot of coding and VBA so if I figured out how to obtain the average time in when the tech arrives on-site versus the time back to…
I'm trying to calculate the value in the Pipeline
This discussion was created from comments split from: How to make a number less than 0 show up as 0.
Sheet Summary with Date Ranges
I have a sheet summary for 4 months worth of data, I would like to be able to populate a separate summary to show only the last 30 days of data. So that I can create a dashboard referencing all the data and a breakdown of the most recent. How can I edit the summary to reflect? Tried filtering and adding a variation of (< =…
RGBY formula
Need help… For the Epex Ready field, I want the ball in the cell to either be red or green. It should only turn green when the 3 fields that proceed it turns green. Any help is greatly appreciated.
How to return a value based on # value or a null value in a range. The # of miles to which zone
Hi All, I have found lots of helpful pieces of information from this forum but I could not locate a previous example similar to this one, My hope is someone else has the same issue too. I am trying to write a formula that returns a value based on the value in another column. In this example the amount of mileage dictates…
Automation showing false result on the formula
I have an automation that is generating false results as you can see below (Remaining Days should be 0). However, when you go the original sheet it is showing correctly (also see below). I disabled the automation and enabled again but the problem still persists. Can anybody advise on the solution? Thanks
% Formula based on another column
Hello - looking for a formula for reading another column drop down selection (Not started, In progress, Blocked, Complete). So when drop down is selected percentage column changes base don that value. Not Started = 0% In Progress = 50% Blocked = 0% Complete = 100% thank you in advance
Auto Add Contact with IF Formula
Hello! I am trying to get a contact to auto populate IF a column equals a certain value. For Example: So if the GC/Owner = Gallo Mechanical, LLC i want the "Submit to" = the AP contact. Can you help me to create a formula? Every version i have tried has not worked. Thank you!
Help Article Resources
Trending in Formulas and Functions
Why is 'DAY' Value from a Date being populated incorrectly?
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but one is getting the correct day from the DATE. I cannot figure out why 10/08/24 returns 9-Oct-2024. Curious to know if…
Counting items in a cell separated by comma
Hello, Thank you in advance. Need help getting the count of the values in a cell that are separated by a comma. Example in a Cell I could have three values: Blue, Green, Yellow. Need to return the value 3 but I can't seem to find that anywhere in the community. Thank you again!
Need a formula for % complete for all phases on the parent project summary row. Row is non editable
I need an average formula in the parent project summary (row 23). Formula should include all phases (initiating, planning, executing, closing). The parent row is un-editable and not allowing me to enter a formula.