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?
Sign in and 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.

Sumif Formula
Hello everyone, could you please help me to find a solution for the following problem: In order to compare our Annual Operation costs, we display our expected(=phased) costs for each month accross all projects. We work here with a sumif formula: =SUMIF([planned/phased/spent]:[planned/phased/spent]; "phased = actual +…
Contain's within cell
I have a sheet that brings through several products per line and then we manually add in lines and split them down so that each product gets it's own line, which we use as a mail merge later. What I want to do is make sure that the products we are manually adding are correct (it's a drop down) so I want to ensure that the…
Index Function Help
I am trying to index data by date and have applied the formula to the column. The problem I am running into is the last data entry is repeating to the end of the dates I have listed for the year even though those dates have not occurred and are not even listed on the sheet I am looking to. =INDEX({Census}, MATCH(Date@row,…
Unify number format to certain number of digits, no display
Hello Smart Heads! I hope you are doing great! Thanks for great support so far! I am facing another issue, this time with number format. In my sheet, I have various calculations in place, including % and others. Thus, I sometimes end up with numbers having non-zero digits in the 3+ place after (.). In other words: These…
Is there a way to delete a cross sheet reference?
I had a working formula referencing another sheet. It was referencing a set of cells in a column. I changed it to look at the entire column and started getting an #Incorrect Argument Set message. I tried to change it back to the range of cells and I'm still getting the error message. I wanted to delete the cross sheet…
% Complete for Checkboxes Marked
Hello, I've looked into similar questions, but I'm struggling in how to write the formula for this. I'd like to calculate % complete of checkboxes marked for each column. Then I plan to represent the % complete in either a dashboard for reporting purposes. From what I read, it should be the =countif formula, but cannot…
Formula help for date <90 days and text "includes"
So really stumped on this one, my formula is working with the exception of the text including "Test". I need to have a star (1) put into this cell IF: Column [Expiration Date] is <= 90 days from today AND another column (Client) includes the word "Test". My current formula (auto-generated) is not working, any help is much…
Need Help To Target Parent Children Field to Trigger Update Request Communication
Requirement : Email notification cascades to other parties as previous tasks get [Status]completed so that they can start the next task. 1.Due Time for first child to take the timestamp from parent and add duration 2. For other children look at the sibling above Auto Numbering column for Parent and Child Assignee at level…
Using Smartsheet to book meeting rooms
Dear community Has anyone used Smartsheet as a calendar for meeting rooms or other spaces. The principle is basically the same as outlook. The basic concept is pretty straight forward and that I managed to implement with a form, calendar, etc. The challenge obviously comes when you want to have advanced features such as…
Workaround for if statement from form
Hello, I was hoping to get some help with a formula/workaround in the following scenario: -A client fills out their information as the "submitter" in a form (Column 1). -The client is asked in the form if they are also the authorized representative from their organization to sign a DocuSign integration (Column 2 - Is the…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

IF/OR Formula Error
I created a formula to populate a field based on the status of various other fields. I got it to work with two conditions (Approved or Declined), but when I add the third (Submitted) with the false response of blank (""), I get an error. Please see the formula below - I assume I messed up something really easy :)…
Average CTR by Type of Ad by Year with DD/MM/YYYY Format
I'm looking to average the click through rates (CTR) by type of ad for 2023 in the SmartSheet Summary Sheet section. There is data from 2022 and 2024 on my sheet, so I'm trying to make sure the data is only calculated between 1/1/2023 and 12/31/2023. I'm using the AVG and COLLECT formulas and keep getting errors. Any help…
formula if then - output number of days
If Written Notice Due (Days) = 30, then Advance Notification days = 90; if 60 then 120, if 90 then 150, if 120 then 240 I will enter the data on Written Notice Due Days column (30/60/90/120) and I need a formula to output to Advance Notifications.

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags