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
how to subtract cells from different sheets with the same id?
In my sheet A I have an ID and a Modify column just like sheet B. I want to subtract the Modify of sheet B with the one of sheet A that have the same ID. can you help me with a formula?
Trying to pull data within a date range - need assistance with the formula
I'm attempting to collect data across sheets and am having a hard time getting my formula right. I want to collect the number of sites in a program that falls into a particular date range. So, I want to pull from our intake sheet all sites in Program A that are due between 1/9/23 and 1/13/23. I've tried a couple of…
Metric Widget alignment Dashboards
Hi community of Smartsheet. Recently I had some issues with the alignment of the Metric Widgets in one of my Dashboards that I build. Before I just choose the data source and almost everything was aligned as you can see below Source: Previous Widget: Now i am trying to include a new one item but as you know, to do that i…
If And Formula for between dates
I'm trying to write a formula to return a "1" if the reference date falls between two dates. The highlighted Q1 should show a result of "1" based on the criteria further down the sheet as shown below. =IF(AND([Planned Date]@row >= $[Actual SIP Date]$177, [Planned Date]@row <= $[shipped On time]$177), "1", "") returns a…
#UNPARSEABLE error
Hi everyone. New to smartsheets and im having issues with my formula. Works fine on google sheets but dont know how to get it working on smartsheet. Please see an example:…
When a date is entered I need the drop down text in another column to change
I have a dated column titles "date sent" where we enter the date when a proposal is sent. I have a second "Text/Number column with various dropdown selections (only 1 can be selected, not multiples). Here what I want to know if i can do: When a date is entered in the "Date sent" column, I want the drop down in the "Status…
IF /and
Hello, I am trying to use a formula to parse out late orders criticality I am looking for a formula IF late days@ row <12 "level one" AND Greater than 12 and less than 15 "level two" AND Greater than 15 and less than 20 "level three" etc Thank you in advance!
Is this possible and if so how do I do it?
I have a drop down list that has locations and those locations are from a space sheet. When the location is a certain address there is a director and manager tied to it in that same space sheet. How do I create a formula to connect the sheets so that for each location the director and manager is also pulled for that exact…
COUNTIF using 2 criteria
Hi, I'm trying to count the number of accounts using Experiencia with following criteria: Rounding Status is Operational AND EHR Status is NOT Operational. I'm getting an unparseable error with this formula: =COUNTIF([Experiencia Rounding Status]@row = "Operational", [EHR Integration Status]@row <> "Operational") Next, I…
I am using the vacation planner template and have a problem with calendar view
As soon as I add a second vacation scheduled in Table View, the previous vacations are no longer displayed in Calendar view. I would like to see all planned vacations in Calendar view. What should I do?
Help Article Resources
Trending in Formulas and Functions