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 returning a blank cell
I have been trying to figure this out for hours with no luck. We've created a formula to automatically update our status column in our project plan sheets. We have specific parent rows that are designated as milestones. The milestone row status cells should update based on the status of the child rows. A milestone row is…
Formula wont work.
Hello, I am trying to use this formula: =IF([Column2]5="","",(IF((VLOOKUP([Column4]5,'Combined Timesheets'!A:[Column2],2,FALSE))=[Column2]5,"Yes",""))) It wont work and I keep getting the #UNPARSEABLE error. Can anyone help me fix my formula?
SUMIF a field if box unchecked
I'm trying to sum a column, [Total Commission], if [Rep] is ES and the [Rep Paid] column does NOT have a check mark. It's looking like this so far: =SUMIFS([TOTAL COMMISSION]:[TOTAL COMMISSION], [SALES REP]:[SALES REP], "ES", [REP PAID]:[REP PAID], ??? (this is where I get lost.) Help?
If a date is within 7 days of todays date
Hi I am trying to create a formula to hight light a cell if the date it contains is within 7 days (prior) to todays date... Can anyone help, I have this working on a spreadsheet but cannot seem to get it working on smartsheet. Thank you
Vlookup/cell linking
Hi All, I've been having a lot of trouble with a vlookup formula that I have linking a sheet with ALOT of columns--just under 200. There seems to be a limit to the number of columns to 'look at' (which is 85.) This is the last formula that I have which works. =VLOOKUP(TODAY(), {1. DOR (Pull-out) Range 1}, 85, false) I…
Problems using IF formula to calculate status
Hello, First post for a new Smartsheet user. I'm trying to do an status formula. If my % Complete column is 0% then the status should read "Not Started", If the % Complete column is 100% then the status should read "Complete", any percentage in the % Complete column that is not 0% or 100% should read "In Progress". I'm…
Formula With a date
I am having an issue with creating a formula that will count a column if a row has a date in it. It can be any date just as long as it has a date. PgM Status is the column with the date right now I'm just counting the section that has the dates but would like to create a formula, so I don't have to keep adjusting in the…
Nested SUMIF+cross sheet formula
I am struggling with a formula. I have two sheets. One is a list of proposals, the other is a material forecast roll-up. I am trying to build a formula that will sum up the square feet noted for a particular product within a certain month and year, but I can't seem to get it right. Here is what I have so far:…
COUNTIFS for Projects Completed Within Past 90 Days
For some reason I can't get this formula to work. I get 0 every time. Using a filter, I can see that number is incorrect. I want to count how many "Course" projects, per organization have hit complete in the past 90 days. =COUNTIFS({Project Type}, "Course", {Organization}, Metric@row, {Completed Date}, <=TODAY(-90))
Range name
Hi everyone, I have a question about the range name and description. When I use formula with another sheet it calls automatically like {range Count}. Later, when I try to find out, which sheet data is being used in the formula, I can't find the sheet and range because I just forgot it and it is not mentioned in the range…

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