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.

Formula - Count by Month and Other Criteria
I've been trying to determine a formula I can use on a SEPERATE Sheet that will pull from the sheet in the screenshot a: - Monthly SUM number of items that are In Review, Awaiting Publication, Published/Live, etc. (i.e., the "Status" column in screenshot) so, for February, number of items in review, awaiting publication,…
Weeks to Project Due
Hi All, I am looking for a very simple formula to help me return the following: The product due date is 10/17/21, week 0, and I would like to create a formula to tell me what working week we are currently in today. I am able Any help is greatly appreciated
Inconsistent results from COUNT(DISTINCT(COLLECT
Hello, I am using a separate sheet to calculate unique names (employees/visitors) who have visited the respective locations, separated by morning and afternoon sessions. I was using Sheet Summary in the source sheet but the numbers don't refresh by itself for some reasons, hence I have created a "metrics" sheet. The…
Formula in Drop Down List
I need to have an excel Drop Down list that includes the "NOW" formula (date and time now) and Pending
Logic Formula: Overall Approval Status
I need help to get this formula right. I have the following scenario but I have no idea how to put the logic into a formula statement. With reference to the following columns, here are the scenario: 1) There are a series of approvals needed from 5 different person 2) If any Approver is "Approval Request Submitted", then…
Formula using OR
Can someone help me I keep getting a error message, I know is has to be the OR function. =COUNTIFS({Civic 2021 Range 2}, "RFP Submitted", OR({Civic 2021 Range 4}, "(Stage 3) 3.2 - WON", {Civic 2021 Range 4}, "(Stage 3) 3.3 - LOST"), {Civic 2021 Range 3}, MONTH(@cell) = 1)
Nested IF Statements
Hello! SS newbie here. I'm having a hard time with my nested if statements. This is what I am trying to accomplish: If number of items in Past Due Count column is =0, Traffic light is Green, 1=Yellow, 2+=Red, and if Status column (Blue Header row) ="Complete", traffic light is blue. I have this so far: =IF([Past Due…
Budget Calculation
I am attempting to calculate the expected spend year to date with a formula that references data in a month column where MONTH(TODAY()) - 1. This works, but when the new year started, it reset all of the expected spend year to date back to 0. Is there away to set a formula that won't =IF(Month6 = "12", SUM([Budget…
Quarter formula with some exceptions
Hi Everyone, What I am trying to do is create a formula that looks at two things, the status column to check if the status is not started or draft. If it is either it needs to return a blank. If it is anything else, it needs to check the End Date column and determine what quarter it is and return the appropriate value Q1,…
Date Helper Not Helping
I created a driver check in and the shipper wonder if there was a way that they could see when a line last pick up. So I used the a date helper and a time helper to separate the information and I used a separate sheet to pull the information. The date helper formula i am using is: =DATEONLY(Created@row) +…

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

Issues with Numbering Children (Child 1, Child 2, etc.)
Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following: Create an auxiliary column with a "1"…
Netdays calculation with optionnal date column
Hi i'm looking for a formula to calculate the netdays between 2 dates. but i have 3 dates in the equation. a date column (date 1) whit references from another sheet and a manual one (date 2) to overwrite the first one. the third date is the "today" date (date 3). so i'm looking for something like: netdays between date 1…
Index/Collect from Descendants
In this sheet, I have a column [Groups] which is a parent column to multiple "Groups", each of which is a parent column itself to tasks associated with each group. I need help putting a formula in [Start Date] of the parent row that would give me the very 1st value from [Date] column that is a Descendant of [Groups]@row…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags