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.

Date ranges and symbols
I am looking for a formula to automatically change a symbol colour based on contract expiry dates. Here is what I need each symbol to signify about the expiry date column - Green dot = If the contract expiry date is greater than 365 days from today Yellow dot = If the contract expiry date is less than 365 days away from…
Formulas and Calculations
Duh!! I figured it out. It was simple. Dennis
Hotkey - Ctrl "R"
Hello Smartsheets Community, I am aware the developers tried to mimic Excel's functionality as much as they were able to, but a fundamental hotkey I use in Excel is "Ctrl" + "R", which allows you to copy any cell to the right of the selected cells very quickly. When I attempt to do this in Smartsheets, my browser (Chrome)…
Help with #Invalid Data Type Error
I have a RYGB column (Color Status) that has a formula =IF(AND(Done@row = 1, [Parent Check]@row = 1), "Blue", IF(ISNUMBER([Days Open]@row), IF([Days Open]@row >= 240, "Red", IF(AND([Days Open]@row > 119, [Days Open]@row < 240), "Yellow", "Green")))) which is working to give me the red, yellow, green or blue ball. In…
Formulas and Calculations
O.K. I have now inserted my formula to calculate a number of miles driven for a given trip. But now I want to copy the formula to the entire column. Right now the formula is just in row 1 of my SS and I know that I can grab the corner of row 1 and drag it down to copy the formula into the other rows but it puts a zero in…
Formulas and Calculations
I know this is a simple formula in SS and Excel but I am having trouble writing it. In one of my SS's I want to Insert a "Beginning Miles" and then insert an "Ending Miles" column and then finally a "Total Miles Driven" column. To me that formula would need to calculated the sum of two entries and then yield a result of…
% Date calculation
Hello, I need to create a % calculation for the number of dates meeting a 'launch' date. What is the best formula to use for this? I will have a long list of dates and I need one column to calculate how many of them are equal to or less than a launch date (25/03/2021). Any guidance would be greatly appreciated. Thanks,…
vlookup vs. Match (identifying new form submissions compared to a static list)
Scenario: * I have a list of 200 customers that need to be surveyed by our team. * Some customers will receive multiple surveys, as they are served by multiple team members (our plan is to compile & analyze the results). * Although to meet our goal, only 1 survey per customer is needed * We are using a Smartsheet form to…
IF Statement to return a Date value
I'd like to create an nested If Statement to return a date based on meeting a specific condition. I'd like to be able to "hardcode" the date in the IF statement. Here is a quick example =IF([Value]1 = "Option2", 4/23/2019, IF([Value]1 = "Option2", 4/24/2019, 4/25/2019)) . If the date is quote wrapped ed "4/24/2019" then it…
Formula to count number of task
Hi, I need help with adding a formulat to count the number of task. I tried adding the formula but it didn't count the task it adds it to the number of task for the above row. I'm fairly new to smartsheet so it's taking me a minute to figure out the formulas. Any help will be great appreciated. This is the formula I used.…

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

Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags