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…
Dear Community, Can you please advise? I have a sheet where among other columns I have a column listing contacts "Champions" (multiple per cell) the other columns are for example: Countries (a list of 72) The list of Projects (approx 15) - I can add to that sheet, or I can create in a Helper Sheet. I haven't done that yet…
I've created a dashboard with multiple graphs using data from the same report. I have added the report to the dashboard as well and set up the filter for use in the dashboard. Is this filter transferable to the graphs as well, given i can filter the report in the dashboard?
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…