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.

NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
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…
Need to compare reports
I am needing to compare an active employee roster (Excel) to a list of users for different platforms (smartsheets and excel). This will need to be able to be done quarterly and show which names are not on each list.
Formula generating -1 for days since last update
Hi! I have a formula that indicates the number of days since the last update. I have 2 different projects that were updated on the same day, but one is showing 1 day since the last update and one shows -1 since last update. The only difference is that the 2nd one was submitted after 5 pm Pacific Time. It's not possible to…
Sheet formulas not updating from Data Shuttle file
Good morning, I have a document that I download from an outside source. I have set up a data shuttle to import it into Smartsheet. I have other sheets that need to be updated based on the info in the imported sheet. None of the formulas are working once a new file is imported. Details: Sheet imported through Data Shuttle…
Issue with Email Notifications via Workflow Automation
Dear Smart Community, I am experiencing an issue with a specific email ID that is not receiving notifications triggered through workflow automation. However, the user is able to receive emails when I send an update request manually. I have tested several scenarios in coordination with the IT team. For example, when…
Gantt View Earliest Start Date
How do I get a row on a Gantt chart to show the earliest date from amongst a set of predecessors? I have a gantt chart where I want one row to display a 0-duration task with the earliest start date from amongst five predecessors. I've entered them as start-to-start predecessors, so in theory it should start when the…
PMO Template - Deleted header row
Hi guys! I’ve been using the PMO template successfully for a while now, but this morning I accidentally deleted the Header info and now all of the metadata for the projects shows #REF for all of the fields. I tried to recreate it as best as I could, but it’s still off. Attached are what they look like. Normally I’m the…
Adding Months to the Same Column
I am trying to setup a sheet that can project dates decades into the future. I want a formula that can look the date in the row above, check to see if it's annual or quarterly, then add the appropriate number of months to each row. While testing the formulas, I keep getting stuck on how to add one year (12 months) to each…
Control Center Error Message
Hi all, I was hoping someone could assist. We were previously able to provision project successfully through control center, however now the automation logs are reporting a failure. I am receiving the following error message on all of the projects I'm attempting to provision: Unable to retrieve Custom fields from Resource…
Form adding rows to smartsheet
I have a form adding new rows to my smartsheet but it doesnt add the next number in the primary key, is there a way to do this?
How can I send an attachment from a line with an automation workflow to a recipient?

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

Adding Months to the Same Column
I am trying to setup a sheet that can project dates decades into the future. I want a formula that can look the date in the row above, check to see if it's annual or quarterly, then add the appropriate number of months to each row. While testing the formulas, I keep getting stuck on how to add one year (12 months) to each…
Index Match Returning No Match?
Hello all. I've searched for a solution but have not found one. I am using an index match formula to return an "employee name" based on a "project name" match. The formula returns no match…but there should be. Scenario: I have a sheet which lists projects including: project #, project name, super, etc. I used a formula on…
COUNTIF Cells within a range are NOT BLANK
Hello, need help with a formula - I need to count within a cell range how many are NOT BLANK, this is the formula I currently have that is not working - what needs to be changed? /COUNTIF(Charter@row:[Retrospective/Lessons Learned]@row, <>"")

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags