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
Index and Match Vs Vlook up
Hi all, I was advised to use Index and Match as I am pulling dates from various schedules into one sheet. Last time Vlookup worked really well however there was a limit of 25000 links. Now I am using index and match and the limit is even low. It says I have reached a limit for cross reference. Kindly advise.
Automatically autopopulate a cell from a cell in the same column based off the date in its row?
I want data I enter to automatically input into my summary table if it is from the previous month. Can you automatically autopopulate a cell from a specific column into another cell based off of the date from its row? For example, can I have the Associate Healthcare number from last month automatically populate into the…
Column formula edit
I was able to convert a row formula to a column formula. However, now I need to edit it and am getting the message that only the sheet owner and admins can edit. I am the sheet owner. What do I need to do to edit the column formula? Thanks in advance!
Copy rows to another sheet with formules
Hello, Is there any way when I copy rows with formules from one sheet to another to keep the formules? Did not work for me so I doing the formules again. Best Rehards, Angela Formiga
Relative Dates
I am trying to duplicate the formulas in another app that uses dates like: every Tuesday, the 3rd Thursday of the month, etc as due dates instead of specific dates.
Report or formula that shows rows not modified for MORE than 30 days?
I understand that a report can show rows modified in the LAST 30 days, but is there a report function or formula that shows if a row has not been modified for MORE than 30 days? Thank you!
Column Formulas and Summary Block
I'm loving the new column formula feature. However, is there a recommended best practice for how this impacts Summary Blocks for which the column formulas to not apply?
Auto Populate dates
Good Morning, Is there a formula that can be used to auto populate dates? For example, I have a date for first visit created, but want a date to populate for "send reminder" 30 days prior to visit and 30 days after. I have created the other columns.
Formula for transferring information between columns
Hello, I am looking to transfer the numeric value from the column named Dept name to the Dept # using a formula. The Dept Name information is autofilled from a form. I would like when a single dept name is selected for the numeric value to autofill in the Dept #. If multiple Department Names are selected I would like it to…
COUNTIF WITH MULTIPLE CHECKBOXES
I have a column called Systems. This allows users to thick multiple checkboxes example "Lighting","CCTV","Intruder".... I would like to issue reports using the COUNTIF formula if the value of Systems has for example "Lighting" ticked in the checkbox. When using COUNTIF it will only count the row if "Lighting" is the only…
Help Article Resources
Trending in Formulas and Functions