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
Is there a way to use Datashuttle on a report?
Hello all, I have a report that I want to export into a google sheet, however, I am unable to find the report when I use the Datashuttle process. If this is not possible, is there a way to import the range from the report to a normal sheet? I have already tried Datamesh but I wasn't able to get it to work. Any help is…
Simple row multiplication formula
Hey all. Looking to have a row for an MSRP where the row shows the suggest 15% markup on a row. For example say row named COST is $100 and I want a markup of 15%, I want to create a formula to multiple COST row * 15% I am multiplying 1 row by a fixed number. I am not multiplying two rows together. What's the correct way to…
Simple sell date - buy date formula
Hey all. Trying to do a column equation that shows how long an item has been sitting on a shelf. Lets call the two columns Sell Date and Buy Date. I'd like to see the amount of days between Sell Date and Buy Date. If I bought inventory on 1/1 and sold it on 1/10, I'd like it to read "9' for "Days on Shelf" column. What's…
Change project complete date based on late tasks
I am creating a project sheet that has a projected completion date and the actual completion date. I want the projected completion date to remain the same and the actual completion date to change if any of the tasks are late. Each group of tasks has a due date based on the projected completion date, i.e. Setup group must…
Displaying all columns following the first instance of a row value
Hello all, I have a tricky question to ask and I'll do my best to explain it. I have a sheet that will continue to grow in length and I need to build a summarization sheet or report from it: I'd like a new sheet or report to provide some of a row's column data associated with just the FIRST instance of a value from the ISA…
Checking a Date Range
Hello, I am trying to figure out which type of formula I would use to allow my project plan to display the correct information for a certain date. My attempt that I keep doing is to use an IF formula to compare the date ranges in the Column with the Today function to see if any are less than or equal to Today's date. If…
% Formula
Hello, I am trying to calculate the % complete within the "Status" column. I have Task labeled "In progress" "Not Started" "Complete" and "N/A". I have Sum formulas set up to tell me how many are complete etc but am looking for a percentage. Any advice ?
Is it possible to get the reference of the First Parent ?
I would like to extract the sub-parts whose biggest Parent is called Media communications. Is there any function that allow us to extract the name of the biggest parent instead of the closer one ? =Parent(Example@row)
Formula for Referencing Cell Above Current Cell?
I have created this Smartsheet, where my team can record orders raised each month. This would then link to a dashboard (which would have to update automatically each month) to show monthly statistics regarding the orders from that month. This is what It currently looks like. Each month is child of its year and the orders…
Forumla not returning any results
Hi I have hit a wall with this formula. The intent is to count the number of attendees where the audiece type =Sellers AND the Status colum is Blue. The dates in am interested in are Nov 1 20201 - December 31st. I have data in my spreadsheet that matches the criteria. I have used the exact date construct in other formulas…
Help Article Resources
Trending in Formulas and Functions