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.
Discussion List
Auto set Baselines
Is there a way to configure smartsheet to automatically set baselines at certain milestones in a project? My thought with this is my project plan would automatically set a new baseline at 3 different milestones, I would end up with 3 sets of baseline date columns. This would easily allow me to go back on projects and see…
AVG(IF) statement based on criteria
Hi Team, Can you please help me write a formulae wherein each KPI has 4 options in dropdown value each representing a certain value as below Partially Met = 100%, Met = 100%, Not Met = 0% How do bring an average value under Score based on the selection in the three KPI. I have entered the Score %s for your reference so the…
VLOOKUP on a Multi DropDown List
This discussion was created from comments split from: VLOOKUP on a Multi DropDown List.
Large Contains Look-up with Multiselect Field
I have a birthday request form where birthday bags are made and then stored. To track where the requests are stored, I have a multi select column named: Inventory Slot Number where a user can select 1-500 and can select multiple numbers like 1 and 2 for example. We get 5000+ requests a year so there will be alot of rows in…
VLOOKUP Issues when referencing another sheet?
I want to preface what may seem like rookie mistakes after rookie mistakes that I am still fairly new to Smartsheet and medium experience in Excel. As the question states, I get a #NO MATCH error when referencing another sheet BUT only when the number in a respective cell is above 100. I imported an Excel file to use as a…
Three criteria SUMIFS
Good afternoon! I am trying my hand at getting some detailed information about hours put in by volunteer by location. What I am trying to pull is from the screen shot in the two attachments. here am I messing up on this formula? =SUMIFS({Time (in yellow)}, {Location (in green)}, {Date (in blue)}, AND Location2 (orange)…
Can I Autofill a column with a formulaic value, like the duration column does?
So, I was recently introduced to Smartsheets and am trying to reproduce the editable autofilling functionality of the Duration column in the sample sheet I was given. I've written a formula to A) check if a row has descendents, and if so, B) define the status of the current row based on the status of the descendents. None…
Formula working in some cells in Smartsheet but not others.
I am using this formula to determine if a particular training asset is on schedule or behind schedule by comparing the draft start and end dates. If the time between is greater than 5 days then Smartsheet returns red and if the time between is less than 5 days, Smartsheet returns green. =IF(NETWORKDAY([First Draft Actual…
Sheet formulas are not auto-updating until the sheet is opened
Is this still a known issue with the TODAY() function OR is there a way to get around it? https://community.smartsheet.com/discussion/59131/sheet-formulas-not-auto-updating?_gl=1*hx7amf*_ga*NDg5OTI2NTg5LjE3MDYwMzk4MDY.*_ga_ZYH7XNXMZK*MTcwNjgwOTkzNi41LjEuMTcwNjgxMDAwMy41OS4wLjA.
Index Match Issues - #NO MATCH
I am trying to perform an index that will output the data metrics based on the given week. I already have things set up to calculate all my metrics based on a data sheet as the data is entered. The last bit where my formula comes into play is so I can have 6 cells output data to a dashboard based on the given week, and…
Help Article Resources
Trending in Formulas and Functions