Want to practice working with formulas directly in Smartsheet?

Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.

❓️Product questions
Sign in andask it here!The community's got your back.

Wondering if there’s a problem?
Check out theStatus Pageand subscribe for notifications.

Check what Support you have access to based on your Plan
Overview of Smartsheet support hours and resources

Share your knowledge!
Help others byanswering questions.

Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Formula (IF Statement?) that checks if row numbered sequentially?
Can I write a formula that could check if rows belonging to same project number have been numbered sequentially? My sheet tracks several projects and each project could have several entries on one sheet and these must be numbered so we know how many submissions were made per project. I wrote one to check for duplicates…
Referencing date and time from another sheet
I am trying to reference an automated creation column from sheet A to populate date AND time in a column in sheet B. I have been successful in the reference, but then have to format the receiving column to date format due to invalid data type. Problem is I need the time to populate as well. Also, when writing this formula…
VLOOKUP
嗨,在一张千的专栏中,我怎么能know the column number so I can use it in my VLOOKUP formula?
Totals from report or sheet summary for dashboard
Hi I have been able to create a sheet summary report and standard report from my sheets - aprox 10 sheets. I want to put a single $ from all the sheet totals into one figure on the dashboard. I can only get the reports to provide individual sheet totals. How do I sum a Grand total from a report? Thanks
connection between outlook and grid
HI, one of my statistic is how many please is present and out of office. This need to be change by employee manually. Is it possible for smartsheet to checking if someone is available and automatically fill status? Thank you
RYG Symbols in Child rows to update parent row
Hi, I am looking to populate the status of parent row to symbol: Red, Green, Yellow Parent Row: Red Symbol = If ALL child rows are red symbols Yellow Symbol = If ONE of child row is yellow or green or all child rows yellow (child row may contain red) Green Symbol - If ALL child rows are green I created this formula but…
Countifs and exclude criteria
我想数数有多少人requesting computers only. I would like to exclude the people that are requesting a computer and internet. I have the formula for the total number computers requested =COUNTIFS(, {Computer Only}, "Computer") but not how to not count the ones that have internet. Can anyone help?
Using COUNTIFS
Hi, I am using the following formula to count those occasions when CSOD (unit) is impacted by CFCD (unit) and the status of the impacts is either 'conceptual' or 'complete' and it does not work. If I limit it to only counting 'conceptual' it works. What I am missing to count more than one status?…
IF formula return RYG symbol based on Status
Hello - I am very new to Smartsheet and am trying to write what I think is a simple formula, but I keep getting an Incorrect Argument error. This is what I need: If Status = In progress, green ball If Status = On Hold, red ball If Status = Complete, grey ball If Status = Not Started, yellow ball
How to check parent row checkbox if at least one of the children row checkbokx is checked?
Hello, i am trying to find out how to check parent row checkbox if at least one of the children row checkbox is checked? Thanks in advance!

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 theFormula Handbook template!

Enter to Win a FREE Conference Pass to ENGAGE 2023

Learn more

=DATE(2023, 1, 1), {OPENED}, <=DATE(2023, 12, 31)) I've been noodling with it but can't seem to get it to work, help would be greatly appreciated!","snippet":"Hi!!! Tried this and it is #UNPARSEABLE: =COUNTIFS({cost savings check}, 1), AND({OPENED}, >=DATE(2023, 1, 1), {OPENED}, <=DATE(2023, 12, 31)) I've been noodling with it but can't…","categoryID":322,"dateInserted":"2023-07-12T21:43:48+00:00","dateUpdated":null,"dateLastComment":"2023-07-12T23:58:49+00:00","insertUserID":159929,"insertUser":{"userID":159929,"name":"MichelleR","url":"https:\/\/community.smartsheet.com\/profile\/MichelleR","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wpHR_5jPu38!XIDR36jCCuc!jzAOxmieF6j","dateLastActive":"2023-07-12T23:53:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":159929,"lastUser":{"userID":159929,"name":"MichelleR","url":"https:\/\/community.smartsheet.com\/profile\/MichelleR","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wpHR_5jPu38!XIDR36jCCuc!jzAOxmieF6j","dateLastActive":"2023-07-12T23:53:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3378406357,"url":"https:\/\/community.smartsheet.com\/discussion\/107529\/cross-sheet-formula-countifs-and","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107529\/cross-sheet-formula-countifs-and","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107529,"commentID":384936,"name":"Re: Cross Sheet Formula, COUNTIFS + AND?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384936#Comment_384936","dateInserted":"2023-07-12T23:58:49+00:00","insertUserID":159929,"insertUser":{"userID":159929,"name":"MichelleR","url":"https:\/\/community.smartsheet.com\/profile\/MichelleR","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wpHR_5jPu38!XIDR36jCCuc!jzAOxmieF6j","dateLastActive":"2023-07-12T23:53:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-12T23:56:07+00:00","dateAnswered":"2023-07-12T23:44:08+00:00","acceptedAnswers":[{"commentID":384931,"body":"

Hi @MichelleR<\/a> <\/p>

<\/p>

Hi @swightman<\/a> <\/p>

<\/p>

Try this:<\/p>

=COUNTIFS({Broth Launch - Responsible}, FIND(Metric@row, @cell) >= 1, {Broth Launch - Year}, PARENT(), {Status}, OR(@cell = Metric21, @cell = Metric22, @cell = Metric23)<\/strong>)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">