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.
Discussion List
Collect Most Current Per Project
We build out contracts and contract MODs on a spreadsheet, the single spreadsheet contains all contracts and MODs across all projects. I'm needing to create a column with a function that reports the most current difference between the original contract and sum of any MODs, per project, per company. Columns involved so…
My Gantt chart does not highlight all the parent rows
I don't know how to fix this. random parent rows are not highlighted in the gantt view. I want to use it on the dashboard, but it doesn't look good. thank you
Is there a formula to calculate years, months, and days between 2 different dates?
I found a formula that calculates the years and months between 2 different dates, but because it's not also calculating the days, it is rounding up the months which isn't going to work in the case that I need it. Here is a picture of what I'm looking for (how many years, months, and days) Purchase Date to Expiration Date.…
SUMS and IF Formulas
Hi I need a formula that sums up the value of children that are checked off in my sheet. I hope i am making sense. So i have a sheet 4 columns, qty x cost. this produces a sum then a column that has check boxes, i only want the formula to sum up those those cells that have been checked off. I hope I am explaining it…
Sum Collect with either or "Demand Stage"
I'm trying to collect and sum dollars from a single column if the "Demand Stage" = "(5) Approved CAR and or "Approved No CAR #". The formula show below works but gives me a $0.00 which I know isn't correct. Any help would be greatly appreciated! Thanks so much.
Cell links and cross sheet references breaking
Recently we've had more and more issues with cell links and cross sheet references not updating correctly. For cell links we're finding that the link breaks, unlinking and re-linking doesn't solve the issue as it just reverts to the incorrect value. A workaround is to un-link the cells, link to a different cell than the…
SUMIF FORMUAL WONT WORK IN COLUMN THAT IS CONVERTED TO A FORMULA
I am trying to sum the net sales for the current month in my "Daily Sales Activity" sheet IF my helper column says "YES" (this is the current month) but I keep getting INVALID DATA TYPE. My formula is =SUMIF([CURRENT MONTH HELPER 2]:[CURRENT MONTH HELPER 2], "YES", [Net Sales]:[Net Sales]) i think its because the rest of…
Is this possible?
Is it possible to have a space sheet where the locations are housed. Then when someone selects the location and submit how do I make it so that if that location is showing for that month of submissions that they are reporting and if their location is not any of the submissions for the month how do i show them as not…
Index Match Else
Greeting All, I have created a simple index match that successfully matches state/province from my reference datasheet to pull in the corresponding district. I would love to indicate "N/A" for the instances when a state is blank but I cannot figure out the argument. =INDEX({District}, MATCH([State/Prov]@row, {Reference…
To show Percentages of a Total in formula
Quick question. if this following formula brings back a numeric value how can i expand the equation to return a percentage of a total. I tried dividing the entire formula by the total row but that didn't work. Any advice. i want the chart below to return percentages. for example, the first row the '3' should say 1 - which…
Help Article Resources
Trending in Formulas and Functions