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
COUNTIFS Formula with Multiple Criteria
I have a formula that counts the 3 test results from another sheet and says that if their Overall Grade is Mastery (Pass) then mark them as Mastery on this sheet. This functions as designed. I now need to take into account a 4th test attempt which is on the same sheet as this formula and I can't figure out how. Basically…
I need a formula that allows the following:
If Modified B has “automation@smartsheet.com” then use Modified By column data but if Modified B is anything else place Modified B data in New Modified By column.
Using a hyperlinked cell in a formula
I have a master sheet that pulls data from many other sheets. Each row feeds from another sheet and there is a column that specifically contains the hyperlink to the sheet that row is referencing. Is there a way to write a formula for an entire column to use the hyperlink to pull data from the other sheets? Example below.…
How to get an "Average" of statuses
Hi team, I am trying to find the best formula to get an average of statuses. I have a helper sheet build out for this purpose. I have certain sub-goals and several projects tied to these sub-goals, each of the projects has a status - not started, in progress and complete. I am trying to find a formula where out of these…
SUM IF Formula
Hi I am trying to sum the number of days based on a criteria - I'm expecting a 6 to come back but, instead I'm getting a 0 I know its something super simple but, I've been looking at this for ages now and can't workout what the issue is! TIA Cheryl
Days since last incident
I've been looking at some older posts but can't find one that matches my specific needs or one that I can find that works, either. The formula I am looking for to help can be explained as: I have multiple project sites that are being captured. I need to have a formula that helps populate my dashboard letting me know how…
Formula to copy contents of a sheet to another
I’m new to smartsheet and am trying to figure out a way to call contents of a sheet to another based on certain criteria, something similar to what Filter function does in google sheets. I am aware that I could achieve this using the index collect function, however the data I am trying to call goes in hundreds of rows. Any…
Previous Values as historical values
Hello all, I am in need of a way to store previous values (mostly symbols showing project progress) into a sheet that would allow for comparison if needed. The main sheet would have current status and a harvey ball symbol either green, red or yellow. Then next week, I want to update based on project status but I don't want…
How to use countifs with dates.
Hello. I am trying to count the number of projects in each quarter for the past 3 years: I tried to use a formula like this to count the number of projects in the first quarter in 2018: =COUNTIF({Service Range 1}; < 1-4-2018) how do I make the formula work? (or is it because the date format is wrong)
Evaluating the most recent date from one sheet and updating another
Hi all, this one has me stumped. In the Last Service Date column for an asset, I'm trying to get the date of the latest service on that asset from another sheet. I have a Sheet- Maintenance Log that has rows of maintenance activities for assets like air conditioners, fans, etc. I have a date from Sheet- Maintenance Log in…
Help Article Resources
Trending in Formulas and Functions
