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.

Formula Help with Symbols Column
Hey, can anyone help me with this? I have a column called Time to Comp which is a dropdown with the following - 5 10 15 30 45 1hr 2hr 4hr 8hr I have another column called TimeCompSym with the 1 - 5 stars. I would like this column to populate the stars based on the value in the Time to Comp column. 1 star = 5 2 stars = 10…
Using VLOOKUP to return a most recent date but with conditions
Hi there, I'm looking to pull off the following: * Smartsheet A is a list of stakeholders we regularly engage with. Every row is an individual stakeholder * Samrtsheet B is a tracker where we list the engagements themselves. Every row is an occasion where we have interacted with a stakeholder. We categorise these…
Having Issues with COUNTIFS function
I have a sheet in which I reference another. What I am trying to do is reference two columns from one sheet to count the amount of entries that match the logical expressions. Here is my current formula. =COUNTIFS({Copy of Incident Report Range 1}, "Burn", {Copy of Incident Report Range 5}, 1) What I want the column to do…
Calculating Time Values
Hi Team, I am new to the community but have been a SS user since 2012. In some reagrds I am still a learner but in my process ability I am building amazing stuff. Let me just say it has transformed my world and clients I work with! I am getting to work with some real complicated setups and trying to translate that into a…
See Current Sheet References and Delete them
I have a sheet i'm building and I have run into the maximum number of sheet references. This isn't a big deal as I've just made another sheet, and i'm going to use a report to conglomerate them, but I found out that I cannot go through my references and delete some of them, or even see a list of the references made. Is…
Parts of a whole inventory suggestions
Hello! we use Smartsheet mostly for inventory management and I was wondering if anyone had some suggestions on how to write a formula to automatically subtract the parts that go into each item while also subtracting the completed part. I currently link in the part inventory from one sheet and update it there so that it…
Report filter not working properly
Hi, I'm not sure if there is an inherent filter mechanism as part of Smart Sheet reports but I am trying to use the report filter function to only show rows for specific information. Column 1 - list of products (e.g. apple, orange, grapes .. etc) Column 2 - list of groups that buys the product (e.g. group 1, group 2, group…
time analysis via modified columns for automated alerts
I'm trying to find a pattern as to how the numbers are generated when two modified by cells are subtracted from each other. At first I thought it was in minutes and separated via location in the number, but upon testing that proved to be incorrect. Does anyone know how to translate the number that is given when two…
Dates Less than 1 duration
Trying to get a formula to calculate less than day if duration is less than 1 whole day. Example - Start date is 7/30/2018 End date is 7/30/2018 Duration is .12d Formula Variable Date is 8/14/2018 If I want to run a formula to calculate the days from Variable date less end date - I get 15. I am looking for something more…
vlookup not updating
Has anyone had a problem with vlookup not updating? I had a situation this morning where vlookup was not refreshing the correct value when the search value changed. The way I found to fix it was to re-type the entire formula.

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

what is wrong with my formula join collect?
=JOIN(COLLECT({Rollup Tracking: Preceptor Activity Month}, {Rollup Tracking: Preceptor Activity Preceptor Name}, [Preceptor Name]@row, {Rollup Tracking: Preceptor Activity QTR}, Qtr@row, {Rollup Tracking: Preceptor Activity Year}, Year@row), CHAR(10)) I cannot see why this doesn't work…i have similar formulas on other…
How can I display data horizontally from data in a row format
I have metric data on a project that I am capturing weekly that I would like to view horizontally week over week for the current month. I'd like to do this dynamically so I can pull the data into a dashboard. This is what I have in my metrics sheet: This is how I would like the data displayed: Any advice you can provide to…
Index Collect partially working
I am trying to validate information using Index Collect function. It works when I look at the school's name, but when I add the 2nd criteria for the school district, I get the #Incorrect Argument Set error. SCID=the ID number SN is school Name in the criterion range DN is the district name in the criterion range…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags