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.

Nesting - Lines Become Un-nested Regularly
Hello. I do very simple nesting: I have a header row and indent related rows underneath it. I have tried doing this both with the doc filtered and unfiltered, but not matter what, within a few hours, several rows will lose their indent and fall out of the nest. Any ideas?
Pasting Data Set
Hi, I have a large data set that I paste into Smartsheet from excel for a Dashboard to populate. When I paste some of the data in that's in 1 cell in excel Smartsheet is splitting it across multiple columns meaning I manually have to amend the data for those rows which is very time consuming.
A workflow has become invalid
Can anyone help me with this? I'm getting an error (below) which I've had in the past and resolved quite easily. This time though I can't find the duplicated name. I do have a system column in both which generates a number but they have different names, is this the problem? Rows can't be added to the destination sheet…
Return value in bottom of column
Is there a way I can get a cell to return the value of the last row? I have a sheet where we all add new info at the bottom of the sheet. I need a summary row to send out the most recent totals to my boss on a weekly basis.
Formula for project status based on where a project is at
How would I write a formula to automatically populate a status column with red, yellow, or green based on where the project is at? In the screen shot below the Implement Asset Works is on-track because the gantt bar is filled in to the dotted line. The Implement Salesforce is behind schedule since the gantt bar is only…
Multiple IF/AND/OR with Dates and Checkbox
I am trying to have a date populated by a formula below is what I have tried and I know individually they work. =IF(AND(Event@row = "Event A", [2nd_Event]@row = 1), Date:Date-25, IF(AND(Event@row = "Event B", [2nd_Event]@row = 1), Date:Date-30)) In both cases 2nd_Event needs to be 1 (Check box) If it was Event A, I need…
How would you delete a Blueprint from SCC?
As subject question raised, can anyone help? Thank you very much.
Filtering top Column
Hi I am wondering if I can filter the Top Row ( RIbbon ) to produce a sheet with a lot of data that I can set up departmental filters and not have to hide columns to do so. It would be great if I could set up a filter called "accounting" and it would show only needed and agreed upon Data - and all else would be hidden…
Populate Text Based on Max Value
Hello, I need a formula that will return the name of the vendor with the most votes for each user. Thank you!
Count the number of distinct subsets of a string that match a criteria
I need to create a formula to count the number of distinct subsets of a string that match a criteria. For example. I have a sheet with a column foo. the foo column contains the following A-Z A-Y A-Z A-X A-Y B-A B-B C-D C-D I need a formula that looks at this column and returns the number of distinct A(s) which would be…

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

NEED TO ADD DAYS TO THIS FORMULA IF ANOTHER CELL HAS SPECIFIC ITEMS OF A DROP DOWN.
I have this formula that works for this cell when information is missing from reference cell A. However now we want to be able to add additional days if reference cell B has specific items checked in a dropdown. I just can't seem to get it to work. Any suggestions. =IF(ISBLANK([ ENGINEER (tentative start date)]@row), "",…
Check a Box if Between Dates on Another Sheet
Hey all, I am trying to build a formula to check off a box on my sheet if at least one date is found between two dates on a separate sheet. I've tried a million variations but here's what I have so far, thinking I was overcomplicating things =COUNTIFS({Approve Date}, >=[Week Starts]@row, {Approve Date}, <=[Week Ends]@row,…
How to Automatically Checkmark a Column for entries that are created within a time-based timeframe
I'm trying to write a formula that will automatically place a checkmark in a checkbox column titled "Today Entry" whenever entries meet the "Created" column criteria of being submitted after 1100 AM the day prior and 0800 AM today on a rolling basis: I've been trying to use the below column, but honestly I have no idea. I…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags