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?
Sign in and ask it here! The community's got your back.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Meeting Room booking using SS Calendar App
Hi All, I'm in the process of setting up a meeting room booking system where I display date/time availability and different status indicators (confirmed, tentative, waitlist). I'm currently using two sheets: one to collect meeting information via a form and the other to manage meeting slots on the calendar. I've…
Comparing Data in two Sheets
Hello, I have a large list of 926 individuals who are identified by IDs in one sheet. some of these individuals are no longer active. I am trying to find a simple solution to compare the individuals in one sheet to the 3+ separate Rosters that hold the active individuals in other sheets. Basically, if they are in a the…
Copying Multiple Values from Cells into One Cell to Add to URL String
I'm pretty good with Excel but new to Smartsheets... I'm trying to take the FirstName and LastName columns and then use the values in those cells to create the values of the URL string to populate in for our RefId= under Link column. What's the best way to do this?
How do I build a formula to count up a specific value based on another column
Trying to build a reference ID that is based on another column's content while counting up the reference ID based on the amount of that specific value from another column. Multiple incidents can occur against the same customer PO and we need a reference number that starts at 01 and counts up if customer PO comes up again…
Issue with ABS function within if statement
I've got a very specific problem with an ABS function nested in an IF function. My formula is basically: IF(ABS(X-Y) <= 0.1,"","Out"). As far as I can tell the formula functions correctly, EXCEPT when X and Y are both values from 7.30 to 7.49. In this instance, if ABS(X-Y)=0.1, then it returns "Out". Ex. when X=7.44 and…
Invalid Data Type
I am having trouble with a formula that is predicting scheduling dates coming back with an #invalid data type when a date isnt entered in the first column. I would like the subsequent cells to remain blank but cant seem to make the formula work. My formula is =IF(((MONTH([Visit 1 (Baseline Visit) Date]@row) + 3) > 12,…
Processing Time (Days)
Hello- Can you help me with my formula? Processing time is "0" should be 1 day. Thanks. =IFERROR(IF(NOT(ISBLANK([Date Recorded Quote]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded Quote]@row), IF(NOT(ISBLANK([Date Recorded CE Leads]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded CE Leads]@row),…
Count if formula help
I am trying to count the total of partially approved awards from an separate nomination process we have running on an alternative sheet. I am using sheet referencing to pick up the data from certain columns. My formula is =COUNTIF({EMEA Local - Line Manager Approval} = "Approve", {EMEA Local - P&L Approval Response} =…
Find the value just before Max?
I am trying to use Smartsheet to keep inventory of products I use incrementally but I am running into a formula issue that I am unable to solve. I have been using MAX(COLLECT()) to pull the most recent inventory check for an item, but I want to be able to pull the previous check as well so that I can compare how much…
Create a Count of how many Not-Completed items to use in Dashboard
Seems like this should be easy but I'm hitting snags. Please see both screenshots below. I just want to create a Count of how many Not-Completed items are on my sheet to bring into a Metric sheet to then display as a Widget # on a new Dashboard. Funny thing is, I've built out some pretty nice Dashboards but I'm hitting a…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Determining AM or PM Shift Question
I there a way to determine if an employee works an AM or PM shift based on the following text? There are appox. 67 different schedules. 4/40 Sunday - Wednesday 8:00 PM - 6:30 AM 30 Min Lunch 4/40 Sunday - Wednesday 6:00 AM - 4:30 PM 30 Min Lunch There are appox. 67 different schedules. Thank you! Ron
Update formulas to new sheet at once without Control Center
Hi everyone. I am hoping you can help me. I have a large sheet and with the new year coming up I have to recreate the sheet. I have a reporting roll-up sheet with lots of formulas and would like to replace all the old sheet reference names to the new sheet. I have tried Find and Replace but thats not working. I manually…
IF/OR Formula Error
I created a formula to populate a field based on the status of various other fields. I got it to work with two conditions (Approved or Declined), but when I add the third (Submitted) with the false response of blank (""), I get an error. Please see the formula below - I assume I messed up something really easy :)…

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags