Formulas and Functions

Archives for March 2018

View formulas globally in a sheet
Both Google sheets and Excel have a shortcut (CTRL+~) that allows you to toggle a view that shows all the formulas in the sheet at once (that is, the cells change from displaying values to displaying the underlying formulas). I find this very helpful to: - Discover which columns I want to shade grey to indicate that they…
Formulas...CountIfs I believe
In process of creating a formula and I can't seem to get it to work correctly. Any feedback is welcome. I have two columns. Both are drop downs. Column Program: A, B, C Column Status: A, B, C, D, E Would like to create a formula that will count how many A's are in Program column WHEN Status column is b, c, or d All…
Report Builder, Using Include and Exclude on Same Column?
Hi, I was wondering if there was a way to get the Report Builder to filter both an include and an exclude in the same column -OR- get it to filter for an exact word or phrase. Example: Filter for a column is set to find all entries that contain the name "john" but that means that a bunch of listings that also contain…
Check if a row is parent and starts with "abcde"
Hi, Please can someone help with a formula to find if a row is parent and at the same time has a text that starts with "abcde".
Counting Projects that are 1 Week or More Behind Schedule
Hi Everyone, I got a great formula from Customer Success that I thought I would share. I wanted a way to know if a project was at least 1 week or more behind schedule. This is what Customer Success gave me: =COUNTIFS(Finish:Finish, TODAY() <= TODAY(-7), [% Complete]:[% Complete], <>1) This formula counts tasks that are 7…
Linking pages
Hey Guys, i am looking for a way to have vital data show up from one sheet onto another. I am using 6 sheets to keep track of project data. Each individual line in the sheets has all of the data for one project. In this line is a check box that states "Ops Scheduled". I need a way to have projects lines that do not have…
Automatically Generate Decision Log from Action Item List
I’m looking for guidance on how I would (or if it’s possible to) automatically generate line items on a decision log from an action item log column value (separate sheets). What I mean is, whenever the value of “move to decision log” is selected from the next steps column in the action item log I would like for a line item…
Vlookup on reports
Hi I'm using a report to pull together a number of different sheets. I'm looking to do a vlookup on the report. Is this possible? If not can I select multiple sheets in one vlookup? Thanks
Automate RYG Balls based on Status and then date
Does anyone have a formula that looks at a line status (Not Started, In Progress, Complete) and then determines whether it is after the due date (red), <7 days (yellow) , or >7 days (green)? Complete would need to turn green regardless of the date while not started and in progress would look at the date parameters. Thanks…
Help with fuzzy match formula
I have no idea how the program thinks that the number 2 even approximately resembles the word "Sparks Corp". I want to use fuzzy math to find the closest vendor name to the one that is typed in, and was hoping to use the approximate match, but am having a hard time understanding what the program believes is approximate. I…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

मीशो कस्टमर से बात कैसे करें?
Meesho खोलें और "सहायता" सहायता टीम संपर्क ∆ O80164×38256 ∆ अनुभाग पर जाएँ। मीशो में ऑनलाइन शिकायत
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…

Formulas and Functions

Discussion List

Help Article Resources