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.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Multiple Projects- Dashboard to track on time delivery
I manage multiple projects, about 20, each with their own project plan sheet. I'd like a report or dashboard that shows me across all the project sheets how I am tracking based on a due date. As shown in the attached project example, I always have a last task which is Project Complete. I'd like to make sure that the…
Traffic light formula
Feel like this should be a relatively simple formula, but can't get it to work! I want to do this: If content due date is greater than 4 workdays from today OR if content submitted is checked return green If content due date is between 1-4 workdays from today and content submitted is not checked return yellow If content…
Formula Autofill Issue
I'm having an issue with autofilling formulas when I add new rows.... I have a sheet with some columns that contain formulas that only reference other cells contained within that row. When I insert a new row and enter data into the primary column those formulas autofill into that new row like they are supposed to. I have…
Linking to smartsheets - '000s of records
we are using Smartsheet for tracking the production items across multiple countries. Each country producing up to 7000 each. We have to be able to show a single database of every country for our client - showing the specific progress on each item but all in one place. Each country has its own Smartsheet I want to link to…
Return a value of 1 if two boxes are checked
Hello! I am looking for the formula to return a value of 1 if two boxes in the same row are checked. Please see the example below. If both boxes in DU and Scheduled are checked, the formula returns a value of 1. If only 1 box is checked, it returns a 0. Any help is much appreciated!
Adding another sheet to Form?
Is it possible to link another sheet to a Form? Example: I have a form created but I want the drop down menu for staff to select to from another form. I have a separate spreadsheet of list of Residents names, I want in my form staff to only be able to select residents from that spreadsheet, so that when I updated the…
Determine Scheduled Hours between dates for Team members
I am trying to create a reference sheet for a dashboard. For some reason I am super stuck. Basically, I am trying to determine the number of hours each team member has scheduled for their projects during the week. I am using the below formula. My columns are Hours, Start Date and Team Member =SUMIFS({Hours}, [Team…
Excel Sheets as the base content for Dashboards
Hi- I have team members that are very resistant to anything new. They want to continue to use Excel for their spreadsheets and wonder if the Dashboard and other sheets that folks use in Smartsheets can actively link to their Excel sheets instead of actually having a SmartSheet. I know that Tableau does this - it links to…
Conditional Formatting Kanban apply on newly added row
Hi all - I have conditional formatting for our kanban view for the task bar color of our cards to mirror our health status field for our project tracker. It seems to be working well once a card is built and the health field changes. However, when a row/card is added to the sheet new, the conditional formatting rule does…
Why is my multiplication formula invalid?
I am trying to create a column that multiplies the total hours by the pay rate of certain staff. In the pay rate column I have used the formula =IF(Name1 = "Sophie", "25.54", IF(Name1 = "Peta", "55", IF(Name1 = "Stephen", "55"))) This formula works well, however if I then try to use those values in another formula is just…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Get a Countif on values in a multi-select column of cells
I am trying to write summary formulas to determine how many values appear of each in the drop-down of a column. I tried adding a wildcard, I have tried HAS, and tried CONTAIN, but I'm still not getting the right values. Currently I am getting 0 as a return value on this formula: =COUNTIF([ROI Type]:[ROI Type], HAS([ROI…
summaries in report
Hi i'm trying to build a report with summaries options. i have two column that i want a Min and Max summary. the column for the Min i a texte column and works well. but the other column has formulas and the Max doesn't works. there is a way to fix that? (instead of creating another text column in the source sheets?) here…
Converting email addresses with hyphenated First and/or Last Names
I am trying to convert email addresses into a Name field with the employee's First and Last Name, capitalizing the first character of each part of the name and keeping the hyphen in any part of the name that has one. I started with hyphenated first names so taking shmoe_joe-bob@company.com and converting it into Joe-Bob…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags