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.

Using a COUNTIFS formula to calculate # of rows in a set date range
I'm trying to calculate the number of tasks completed in the prior fiscal year, to be used as a dashboard metric. I've created a sheet that uses a COUNTIFS fomula to reference the relevant column in another sheet. Here is my formula, which returns a '0' result. =COUNTIFS({Completed Date},">=07/01/2017",{Completed…
Tips for Showing Count of Answers Completed on a Smartsheet?
If I have a section with three rows underneath my heading, I'm able to easily use a formula to show the count of tasks completed/responded to out of my total number: ="Introduction: " + COUNT(Response4:Response6) + " of " + COUNT(CHILDREN()) However, if I have a section with multiple sub-sections, I'm struggling to use a…
Display a counter in a bar graph
Hi community, I'm making a bar graph which shows information in %, so each bar is the percentage of the information I want to show, but this '%' comes from a scalar number which I also want to display. Is there a way to do this? I attach an example.
Automatically marking something as complete when requirements are filled
Hello, I was wondering if someone would be able to help me with a problem that I have been struggling with. I would like to make it so that when a checkbox is checked, in another column, called status, that it would switch and say complete. The status column is a Dropbox, containing Completed, In-progress and Not started.…
CountIF incorrect
Im trying to count the number of total number of "Open" "Risks" in another sheet =COUNTIFS({RAID Log Range 1}, "Risk") + (COUNTIFS({RAID Log Range 2}, "Open")) I only have 1 open risk but its returning 5. This is because its counting the total number of "open" AND "Risks" into my count. How do I write the formula to be…
Card View - Data Entry (Logic & Formulas do not show up)
I went through a lot of trouble to program my Smartsheet with formulas and logic to make sure the data entry was sound. Only to discover that when someone enters data via the card view, things to not do what they do in grid view. I have many columns to populate and the entire point was to make it easy and smart. Does…
Formula help on IF ELSE
I want to have a condition where IF Delivered column checkbox is checked, then that whole row will be deleted. Is that feasible? Can you please guide me how to start with it?
Formula Help
I am trying to match a cell on our contract status report and pull that cell information into our recruitment sheet. On the contract sheet name is in the first column and contract status in the sixth column. I want the contract status to populate into a cell on the recruitment sheet by name. I was thinking that VLOOKUP…
validating cell value
Hi, I have a sheet with diferent columns, one is "Initial Date" and other one is "Ending date". How can avoid users update "Ending Date" with a date earlier than today?
Nested IF Statements for same date
Hello, I'm trying to create a Nested IF formula utilizing the status bars and due dates. What we're trying to say in English is: If more than 5 days til due date = Green If within 5 days of due date or equal to due date, = Yellow If past due date = Red I can get certain parts of the formula to work by themselves, but…

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

I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")
Formula Help
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our company. The issue is that it returns it multiple times. So the expected result is "four", the formula returns "four"…
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags