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.

Formulas and Functions

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

Move Rows with Auto-Number System Column - retaining an auto-number value
Hey everyone, I am working on my first automation to move a row from Sheet A or Sheet B to Sheet C when the Approval Status is Declined. Sheet A is a list of a specific type of project and Sheet B is a list of a different type of project. Sheet C will essentially be a Backlog project list. Both Sheets A and B have an…
Automated Workflows not triggering
I have a sheet that collects responses from a form and when a row is added, a workflow should then be triggered to record the entry date. This would then trigger another workflow to copy the rows to another sheet and nothing… Even though the criteria are met, the workflows are not triggering and IF it does, it takes a long…
Average value of responses from survey
I have a customer satisfaction survey with 10 questions all returning numerical values. I want to know average satisfaction based on the responses but i am getting a unparseable error with every formula.
Sumifs + Contains Formula
Hello! I’m trying to sum the total hours from another sheet based on a specific name and a time activity code. Since there are multiple activity codes I need to consider, I’m using "contains" in my formula, but I’m having trouble getting it to work correctly. Here’s the formula I’ve been trying: =SUMIFS({Timesheet Summary-…
Using multi-select dropdown list as criteria for Index/Match Lookup with SUMIFS
Hi all — Looking for some guidance on the below… I have a sheet named "Tracker" with a dropdown column of job levels (named "Target Audience") and another column that I am wanting to sum the job levels from whatever is selected for that row ("Total Target"). The totals for each job level are pulling from as a cross sheet…
Numerical value established by a formula not seen as a number
Hello I have used the mid formula to break down a date and indicate the number of the month only in a field. =MID([Start Date]@row, 2, 1). This is all working fine. I want to run an automation where if the value of this field is less than 5 do x. However it is not seeing the value as a number and is thus returning zero…
Select Most Recent Date In List
Hello! I need a formula to pull the most recent date in a list, but I keep getting unparsable and invalid errors. Could someone please help me create a formula to put in the highlighted cell? Please note there are empty dates (like the top row). This sheet is driven by a form, so new dates may be added out of order - in…
Formula or Automation to Indent Rows from Intake Form?
Is it possible to set up a formula or automation with helper columns in a sheet so that if a box is checked (or some other designation that could be done from an intake form…) it can indicate that a task is a sub-process of a larger task and be indented to indicate that relationship? Trying to find a way around manually…
NETDAYS Count Stop
Hello, I am trying to figure out what the correct formula would be in order to stop a NETDAY Count. What I have is a: Creation Date Column that is the "Inception" Column. Then, I have an "Open Days" Column that is tracking the number of days this has been Open for. Finally, I have a "Closed Date" Column. What I am looking…
SUMIF by month and by year
I have a metrics sheet with a cross sheet reference where I'm calculating a sum for each month with the below formula: For January =SUMIF({Refund Issue Date}, IFERROR(MONTH(@cell ), 0) = 1, {Refund Amount}) For February =SUMIF({Refund Issue Date}, IFERROR(MONTH(@cell ), 0) = 2, {Refund Amount}) and so on. How do I include…

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 the Formula Handbook template!

Trending in Formulas and Functions

Referencing a specific level in a hierarchical setup
Hello, I am trying to do a count of statuses on a sheet but I need it at the second child level. In many cases there are children below this level also that I want excluded, and I also do not want to include anything from the parent levels above either. I do have a helper column that assigns a number code to each row with…
Formula for Auto Reference Number
HI cpould it be possible to indicate time hour and minute in a formulated column i have sample formula in here but its still unparsable i able to create and test with some helper columns but still didnt work =IF([Case Type]@row = "Internal Service Issue", "ISI", IF([Case Type]@row = "External Service Issue", "ESI",…
Formula to separate first and last name from Contact List
Hi everyone! I'm trying to separate Last Name and First Name from a Contact Column. I'm CLOSE, but it's not QUITE working. I tried to take a formula I saw on another thread, but because I don't actually have an understanding of what the formula is actually doing, I'm unable to trouble shoot why it's wrong. It seems to be…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags