Formulas and Functions

Archives for October 2022

Fields Will NOT Add to Form After Completing Formula
I recently had a Pro Help desk call to figure out how to add a pre-populated field to a form. We got it working easily and I will paste the formula below (we added the Work Order ID field to the form because it tends to be filled out incorrectly). =FormLink?Work%20Order%20ID=" + [Work Order ID]@row I tried to write this…
How to construct an IF statement forumla for a symbol column?
I have created a list of project milestones and would like the symbol column to auto-populate depending on the values in the "Start Date", "End Date", and "Status" columns. I am not certain if the status and requirements (listed below) for each are flawed or if it simply a formula issue. Fields: Red = "Past Due/Issue" -…
Countif Reference Equals Name @ Row or CONTAINS
Good morning all. I am trying to create a COUNTIF formula that counts the amount of times a station is listed on the reference sheet if it equals the name at row. I have tried the following two formulas which return 0 when they should be returning the number in the 2022 column: =COUNTIFS({Station Count}, CONTAINS(Name@row,…
Help needed to gather data from multiple sheets to calculate
Community, I am really hoping you can assist me with this. I am creating a process to reconcile quantities of medications at a location. So, here are the details: I have 3 sheets, AM Count, Controlled Substance Dispensed and Controlled Substance Restock. All 3 sheets' data is submitted via a form by an end user. The AM…
Pre-chosen date based upon name chosen
Hey all. Is it possible to set template date(s) in a group of cells when another cell drop down is selected? For instance, If I choose from a drop down "June 2024" the dates cells next to this would snap to certain dates (milestones) automatically. Trying to have x4 milestone dates snap when a "Month Year" is selected. Can…
How to turn off the Project setting in smart sheet?
I would like to turn off the Project setting but it looks like it is impossible. All I need is to reset the start date & end date columns. Does anyone know about this? Thank you!
Nested Ifs that output VLookup results.
Hi folks, Back again. I have a Pricing Tier dropdown that has three options. "Tier 1 - Small", "Tier 2 - Med", "Tier 3 - Large" I now have a separate cell that needs to have a formula that checks the value in that pricing tier cell and based on a match, it pulls the output of a VLOOKUP. I can get it to work singularly, but…
Returning Partial String
Hello - Is there a function that can return only the number values in the below example? Kelsey Comeau (204938) Thanks! Ron
IF / AND / #INCORRECT ARGUMENT SET - Formula Help
I'm trying to assign a "Status" column of Not Started, In Progress, Overdue, Complete, or Not Applicable (if a box in another column is checked), and am getting an error of #INCORRECT ARGUMENT SET. Appreciate any help. I've spent way too much time on this. :-) =IF([% Complete]@row = 1, "Complete", IF([Task Not…
Copy from a different sheet if a condition is met
If a company department matches, I want to copy a cell (score) to another sheet. I am trying multiple formula combinations but receiving error messages.

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Upcoming Events

Brandfolder Collaborator User Guide
Get ready to seamlessly upload and organize content within your Brandfolder! This on-demand session is designed to help you become a confident contributor and collaborator, ensuring your team has the right assets at the right time. What You’ll Learn: Maximize Features in the Asset Modal: Learn to navigate the asset modal,…
Brandfolder Admin User Training
Managing digital assets doesn’t have to be complicated. Join us for this two-part, on-demand webinar series designed to give Brandfolder administrators the confidence and skills to create smooth, efficient workflows. Whether you’re just getting started or ready to optimize your setup, these sessions will help you unlock…
Smartsheet Customer Success Onboarding (Japan)
Smartsheet カスタマーサクセスオンボーディングは、Smartsheet についての基本を学びたい方向けに毎週開催しているインストラクター主導のトレーニングコースです。ウェビナーは、始めるための基本、共同作業、およびさまざまな方法での作業の視覚化の基本など、Smartsheet のご利用を開始するために必要なすべてを網羅しています。

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Need Help With Date Calculation Formula
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
Formula help for INDEX MATCH. Or is it INDEX COLLECT?!
I have a holiday sheet for Team Members to log their holidays: Assigned To, Start and Finish Date. A formula has been created to flag the status of when they are ‘On Holiday?’: eg, ‘Holiday Complete, ‘On Holiday’ and ‘Holiday Booked’. Based on this status, an ‘Availability’ symbol also appears Id like to use this…
How to add multiple costs from dropdown menu items
Hello, I am struggling to identify a formula that can read multiple selections in a drop down column, find the corresponding selections and prices on another sheet, and return a total cost. The sheet supports samples that are analytically tested. The user chooses which tests they want to conduct for each sample on the…

Formulas and Functions

Discussion List

Help Article Resources