Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Sign in to ask your formula question or join a discussion.
Check out a list of all the available functions in Smartsheet.
Download the Formula Handbook with 100+ formulas and in-sheet examples.
An article with frequently used functions and additional resources.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
Looking for assistance again, I want to bring in the % complete from the Production sheet to the Schedule sheet, but once the % complete is 100 the data is moved to another sheet, so I would like to reference to check 1 sheet for percent complete and if it is not there check the second sheet. Schedule sheet: Pick Up Date…
I have a schedule sheet and a production sheet, I am trying to pull the pick up date from the schedule sheet to the production sheet based on an Order Number, which on the Schedule sheet can be surrounded by other information. Schedule sheet: Pick Up Date field is a date field. Production sheet: I have tried:…
My formula keeps yielding 0 in the results: =COUNTIFS({TG-18 Range 1}, 1, {Phase}, "Phase 2") I am trying to count how many Phase 1's are checked from another sheet: My Lastest Phase Completed column is a "Checkbox Column" that has a formula based on submission date and my Phase column is a dropdown. What am I missing?
Not sure what to title this, because it's not really Cell Linking the way we talk about it with Smartsheet… I have two sheets, Project Sheet has project rows and a column that lists animal species impacted (currently text, but could be multi-dropdown if that helps?). The second sheet (Species Sheet) has "more info" on…
Can I add a note to multiple records at the same time?
I have a single sheet with a unique ID number (this is equal to the row number) and an organization name (among many other fields). The organization name will appear multiple times in the organization name column. I want to create a new column that collects each ID number when the organization name appears, separated by ",…
I’m trying to create a reliable Submitted Date column based on the Smartsheet Created Date system column. The goal is for Submitted Date to capture the correct calendar date when the form was submitted and then remain unchanged. The issue is that the Created Date timestamp appears to be displayed or evaluated differently…
Is there a formula I can use that will "divide" a page? I have about 2,000+ records on each page; And for the sake of backup, I need to divide it out into units of 500. Whatever the final item is will probably contain 500+ records. Such as 4 new sheets of 500, and then 1 sheet of 600 for example? Is there any formula I can…
Trying to figure out a formula to calculate if a date is 6+ months away, 3-6 months away, <3 month away, or if the date has already passed. The desired output is 1 if 6+ months, 2 if 3-6 months, and 3 if <3 months or already passed.