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
How could we convert the day to year?
i have tried to number of days divide by year, seems not working
How to use If and and?
I have 3 columns A, B, C I need to write a formula that will return Column C based on the values of Column A and Column B. If Column B=3 AND Column A is between 3.5 & 4.4 then return 4 If Column B=2 AND Column A is between 3 & 3.4 then return 3 If Column B=2 AND Column A is between 3.5 & 4.4 then return 3 I am able to…
Inserting Symbols and Emojis
Is there a sheet that provides a list of alt codes to insert different symbols and possibly emojis? Thanks
If "Status" Changes Email "Form Submitted by"
Good afternoon, I am reaching out to ask how to set a rule for when a column changes, to send an email to the person who submitted the form. I have a form that populates a sheet. I would like to set the rule "If status changes, notify person who submitted form." Is this possible and what would that rule look like? Thank…
Index Match Across Multiple Sheets
Hello Smartsheet Community! I have reviewed a few similar posts on this subject, but have further questions ... Examples shown on other discussion threads, show to use stacked IFERRORs, and repeated Index/Match in the formula to look at multiple sheets, however I am not able to get this to work. When you're stacking…
=IFERROR(INDEX(COLLECT(
Moderator Note: Translated from French to English via Google Translate Hi there, I want to use the =IFERROR(INDEX(COLLECT() function to combine multiple data from different columns into a single column. So I adjusted this function according to my need: =IFERROR(INDEX(COLLECT({Dys D1}; {Dys D1}; <>""; {Dys D2}; {Dys D2};…
Countifs Formula Referencing Another Sheet
I could use some help with a formula that references another sheet. The sheet I want to reference is titled: Certified Roster Status The sheet has a number of columns. But, there are two columns for which I want to use the criteria for the count. I’d like to get a total count from the column called Status when the word…
Split text into columns
I'd like to split text into separate columns. The text (found in one cell) has the following form: company name-document type-yymmdd-version number E.g. I'd like to split Architecture-Proposal-221129-001 into four columns: Company Name Document Type Date Version Appreciate any help or advice. Thanks, Jacob
IF Function
Hi All, Attempting to write a formula and running into incorrect argument errors. If DateA is after DateB OR if DateB is after DateC then = "1"
DD/MM/YYYY Date Column Format
Hello - can there be an option for date cell/column formula to be a DD/MM/YYYY format for Long Date? I understand I can go to my user settings and select English (Malta) which gives me MM/DD/YYYY but that is not the option I want/need. I would also prefer not to have a helper/formula column to make this change.
Help Article Resources
Trending in Formulas and Functions