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
Is it possible to automate a formula across new sheets
In order to feed information into a dashboard, I am importing an excel sheet on a regular basis. Is there a way to have a formula automatically generate into each newly imported sheet, so that specific information is pulled into a metrics sheet? The formula would need to pull from the new sheet each time, but from the same…
Project intake from non owned non admin shared sheet
I am new to the smartsheet program, and learning quickly, but I have a new problem I am trying to work through. I have shared access to a vendor smartsheet that does one piece of my customers work. This shared is a tracker that has multiple sheets funneled into one sheet. I am wanting to import key information from their…
Trello Integration
Does Smartsheet have plans to integrate with Trello?
Contacts in a column from another sheet to a separate sheet
Hi, I was wondering if anybody has an idea on how to accomplish what I am trying to do. I have a sheet where there is a column formatted as a contact list. There's approximately 100 rows, each with an entry of a particular person. Some people are duplicated in the row. I have a separate sheet (for a different purpose).…
Can you check / help with my IF, AND, NOT ISBLANK formula
Hi all, This is my first post :-) Hoping for some help with a long IF formula. I have sheet that has columns with dates in them Launch Date, then Nomination Deadline, then Survey Deadline - in that timeline, so there won't be a survey report deadline after a launch deadline. Sometimes these dates are not filled in. I am…
#REF on formulas
I am receiving a #REF error when trying to countif from a master data sheet. I have not updated or modified anything in this sheet or the one the data is pulled from. I also tried deleting a the formula from a few cells and starting new but the #REF error still occurs. Is this functionality down? Thanks!
Cross-sheet References in Formulas Generating #REF Errors
This formula has been working for years, with no changes to the underlying structure. Any ideas? I see that this eventually resolved itself for other users, but it's been a couple weeks for me.
Once due date is met, start new row based on recurrence interval
I have some reports that are due at different intervals, 1 year, 5 years, etc. I want to create a formula (or method) that when the due date is reached it will set the next due date. It would actually be neat if the system would generate the next line, but I can live with just doing the formula. And need to due this if the…
Formula for a PASS or FAIL
I would like to add a formula to the sheet that shows a Pass or a Fail depending on three other columns. If Mold Present column say "No" & the Seeds per 100g column says "None" or & the Foreign Matter column says "No" mark the cell as a PASS. If Mold Present column says "Yes - Beige" or "Yes-Grey" or "Yes-Black" & the…
Updating one formula reference is updating all formula references.
I have several formulas that reference a different sheet. When I update one formula it updates all other formulas that reference that sheet regardless that I've pointed them to different sets of data on that sheet: For example - the above formula references the sheet Lafayette Square but the column with dollar values that…
Help Article Resources
Trending in Formulas and Functions