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.

Task totals across multiple plans & within a set timeframe
Hello! My formula skills are pretty basic so I feel like this might be a bit more than that. I am trying to calculate the number of tasks for four departments across multiple project plan sheets. I want to look at a timeframe scale of the last 3 months and the next 6 months. The four departments are: Editorial, Design,…
Using all three If, And, Or function
Is there a way to use If, And, Or altogether? What I am looking for is, If Task 1 Or Task 2 shows Fail, check New Task. And if On Going or Resolved is checked, uncheck New Task.
INDEX(COLLECT - #Invalid Value Error
Good afternoon everyone! Looking for some help with INDEX(Collect. I have a main sheet set up and also have created a helper sheet. Once the install date on the main sheet is changed, automation copies that row to the helper sheet. I want to see on my main sheet the previous install date as well. This I've figured out. I…
Is it more resource efficient to use @cell or @row?
I can't find any reference to an explanation for when to use @cell versus @row and whether one is more resource efficient than the other. Can someone clarify this for me?
formula for determining time duration between CREATED date and MODIFIED fields
We log all of the voicemails that come into our office. I am trying to track the time that it takes for each person to respond to each VM. The log each time that they try to contact the customer. I am trying to track the response time which is the time elapses from the date the voicemail was assigned (CREATED) and or…
Is there a way to make details required when a project task due date is changed?
On a project sheet, I want to capture when and why a due date has changed for any given task. Is this possible via a formula in the sheet? A workflow? What is the best practice in capturing this?
Looking for help to modify an Index formula to combine previous entry's from forms
Hello, I have a dashboard that displays form submission data using this formula:=INDEX([Submission Date]:[Open Space Link], 1, 3) Current Behavior: The formula shows the most recent form submission When users submit partial updates (filling only 1-2 fields), only those new values appear on the dashboard Previous valid data…
Invalid operation on formula that's been working
This discussion was created from comments split from: Intermittent #Invalid Operation error.
Help converting Excel formula to Smartsheet
I imported an Excel file into Smartsheet, and am stuck trying to convert this Excel formula into a functioning Smartsheet one. I know some of these functions are not available in Smartsheet. However, I've tried a lot of different formulas and am still having trouble. I've even tried using ChatGPT and it's proven to be…
Is there a way to have the "Date of Next Review" pre-populate based off another column?
If I enter in the date of the reviews for 2024-5 and SmartSheet is aware that the review frequency is annually, biannually or quarterly, is there a way to have the "Date of Next Review" fill in knowing when it should be?

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

Weighted Check box's
Just looking to see if there a is a better way to do this. i know i can Write a LONG IF statement to do this. i would like if Step 1 is Check Step Percent would %20 If Step 1 and Step 2 is Checked it would = 75 % if Step 1,2,3 are Checked it would = 95% if step 1,2,3,4 are Checked it would = 100% just looking to see if…
My formulas on my Metric sheet are calculating 0 and I'm not sure why
Hello, I am trying to create a dashboard with widgets to display our overall progression on multiple projects. I was told a Metric sheet would be best to do this. I am creating my first metric sheet but the formulas are calculating 0 and I'm not sure why. In the first section below I am wanting to add up how many projects…
How do I use Cell reference in a formula when using Index?
I have a simple table that has the following columns (along with other columns), ZZZ YYY 10 15 and I would like to replace the ZZZ and YYY in the following formula =INDEX([Thing1]ZZZ:[Thing2]YYY, 1, 1) With the data from the columns above so that the resulting formula would be: =INDEX([Thing1]10:[Thing2]15, 1, 1)

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags