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.

COUNTIFS + OR
Each quarter completed jobs get moved to a Completed Sheet for that relevant quarter. However, some of the tasks done on that job needs to be reported for a previous quarter. An example of a task would be a Preflight Review, which takes place at the onset of a job, meaning the job is very likely to complete in a following…
How to Match Regions to States in a Column
I am creating a sheet that needs to identify the "region" based on the "state" in the preceding column. I've tried multiple formulas and get back an error message (unparseable). What am I missing? =IF([State]1=ny,nj,ct, "northeast",IF([State]1=nc,sc,ga, "southeast", IF([State]1=ca, az, nv, "west")))
VLOOKUP/IF or INDEX/MATCH?
Hello, I'm not sure which combination of formulas I require (VLOOKUP, IF, INDEX, MATCH...) In sheet 1 I have the columns "resource name" (text) and "onboarding paid?" (check box) In sheet 2 I have the columns "resource name" (text), "onboard?" (check box) and "milestone paid?" (check box) If the resource name matches, AND…
Checkbox Column + % Complete Column Formula
Smartsheet I am trying to use this Formula to calculate % Complete based on Checkbox, however the Checkbox is a different Column Called Done, not under the % Column. Can I do that? Existing Formula: =ROUND(IF(COUNTIF(DESCENDANTS(), 1) / COUNT(DESCENDANTS()) > 0, COUNTIF(DESCENDANTS(), 1) / COUNT(DESCENDANTS()), 0) * 100,…
Sheet Summary - SUM Chilldren Rows based on Status and Dates
Good Afternoon! I am trying to sum children rows where certain status' exist where the Pick-Up Date is today, within the next two days, and in the future beyond that. (Really, 3 formulas). I tried applying the following formula before involving dates to make sure the first part of logic is correct but it is giving me an…
Display Value IF Between Two Dates
Hello, I'm trying to create a formula that will display a specific value if a date falls within a certain range. Any assistance would be greatly appreciated. If “Target Update or Replacement Date” is between 10/01/20 and 09/30/21, then "Budget in Fiscal Year" = “FY 20-21”. If “Target Update or Replacement Date” is between…
#INVALID REF for Widget
Hi Community. I'm hoping someone can help me out. I created a task tracking sheet. A general rule is that our reporting month is always two month behind today. In my sheet summary I have a formula using index match, which works perfectly to my expected results. I am using a date reference table so I can see the month name…
SUMIFS Formula
Hi, I am trying to sum the numbers in the first column where the states are CA, CO, DC and IA. Could you please help. I a still learning formulas in Smartsheet. Thanks!
Date Range Formula
Hi, I'm trying to set up a formula to count the number of requests that were submitted between a specific date range. Below is the formula that I've written, however I'm still receiving an invalid operation error. Can anyone help me with this? =COUNTIFS({Citi Table Change Tracker Date Submitted} >= DATE(2019, 1, 1), {Citi…
if then... do this query.
In the below - column Principal Check I have put: =if([Principal survey drawing required?]2="Yes",[Principal drawing validated?]="Awaiting response","Not Required") I am wanting the Principal drawing validated? column to have an entry, "Awaiting response" based on Yes in column 'Principal survey drawing required?' column.…

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

मीशो कस्टमर से बात कैसे करें?
Meesho खोलें और "सहायता" सहायता टीम संपर्क ∆ O80164×38256 ∆ अनुभाग पर जाएँ। मीशो में ऑनलाइन शिकायत
Get a Countif on values in a multi-select column of cells
I am trying to write summary formulas to determine how many values appear of each in the drop-down of a column. I tried adding a wildcard, I have tried HAS, and tried CONTAIN, but I'm still not getting the right values. Currently I am getting 0 as a return value on this formula: =COUNTIF([ROI Type]:[ROI Type], HAS([ROI…
summaries in report
Hi i'm trying to build a report with summaries options. i have two column that i want a Min and Max summary. the column for the Min i a texte column and works well. but the other column has formulas and the Max doesn't works. there is a way to fix that? (instead of creating another text column in the source sheets?) here…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags