Formulas and Functions

Archives for August 2018

Static Cell References
I have a list of expenses paid to vendors. The same vendor may appear in the list multiple times. I am trying to figure out a way to summarize all payments to vendors. I had looked for the ability to do a report and show the "top 10" vendors, or a pie chart, but could not get those options to work. So, I wrote a formula…
Stop counting months when a completion date has been met
Hello, I need to have a column that calculates time in a program from a start date freeze when the employee's status changes, it needs to keep counting as long as the employee is still "Active" in the program. I'm working with "Status Code,", "Enrollment Date," and "Date Licensed/Dropped" columns. I have this column set up…
Agile Backlog and Sprint Dashboard
Hi Everyone, I've recently upgraded to the business version to use the Agile Dashboard tool for a software development project I'm working on, but I'm a novice Agile practitioner and I can't find much training about how to build and use the dashboard tool. Does anyone have any ideas about videos or other training? Thanks.
Sumif Circular reference
Hello, I know this is possible within Microsoft Excel, but do not know if it is possible within smartsheet. Trying to do a sumif formula across multiple rows and only change "[Assigned To]1" from to "[Assigned To]2", and for row 3 it would be "[Assigned To]3", etc. using this formula =SUMIF([Assigned To]:[Assigned To],…

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!

Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…
How to count a field which has a certain character in it.
I have a field with the date formatted as 09/30/2024. I would like to summarize that field with the count of lines containing 09 and 2024 (so basically by the month and year). I am attempting just for the month and can not get it to work. =COUNTIFS([Next Renewal Date]:[Next Renewal Date], CONTAINS("09") But I would also…
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…