Formulas and Functions

Archives for November 2020

Adding Attachments to Workflow Notifications
If an attachment was added to a submission form is it possible to have that attachment added to an "Alert Someone" Workflow notification? Ty
#Invalid Operation when attempting to find difference between two cells
Good afternoon! I am trying to get the difference between two cells (both from formulas) but get the "Invalid Operation" instead. I know this is simple and I'm overlooking something!
Referencing a Lookup Table
Good afternoon, I am rather new to Smartsheet formulas. I am trying to reference a lookup table column. Please see screenshot. In the main table, I would like e.g. "MM" to autopopulate when Mickey Mouse is entered in the FULLNAME column. Whether I try VLookup or Index/Match in the FULLNAME column of Main Table, I receive…
COUNTIFS with OR included
Good Afternoon, I've got a doozy of a formula that I just can't figure out. I've been on the phone with smartsheet and it is still not counting correctly. Here is what I need it to count: -Range 1=on or before 12/1/20 -Range 2: Consultant name listed in the row -Range 3: Blank OR (on or after 1/1/21) Here is the formula I…
I need to set up an update request for when a box has been checked for 2 weeks
I have a two condition update I'm having issues with: If box is unchecked x2 weeks and no date is in the date column, send an update request. Can someone help me do this?
If formula using dates and adding to date
I need guidance on making a formula that takes a date and compares it to today and then adds a number of days to it based on difference. If <30 add 15 If >30<45add30...
Dates - Due, Complete and Overdue based on Completion Date
I have a due date and completion date columns in my Smart Sheet and need help with formula to give responses based on dates. I have attached example for reference. For column with completion date being blank, would like to show "Due", for completion date before due date to show "Complete" and completion date past due date…
Is It Possible To Clear Entire Sheet Without Clearing Formulas
Hi everyone, I have a smart form that takes input from a user. This data then goes into the sheet - where there are complex formulas within to make certain calculations - later used to create certain metrics etc. The nature of this sheet means that it will be continually added to, meaning at some point, it will be a good…
Error Message with my SUMIF Formula
Hi, I'm attempting to do a simple SUMIF formula, summing up sales per month. This is the formula I'm using: =SUMIF([Contract Date]1:[Contract Date]51, MONTH(@cell) = 10, [Cost of System]1:[Cost of System]51). The Contract Date is the column that has the date and the Cost of System contains the sales figures I want to add…
How to calculate number of text occurrences in column and return a number
I am trying to calculate when a Y appears in a specific column and return the number 2 when this occurs and 0 when is N, any ideas on best formula have been pulling hair out!! Thanks

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Trying to calculate the number of submissions
We just ran a survey in Smartsheet using forms, and its going through the next 2 weeks, i want to gather how many we have received from our survey document and display it on my metrics, to then display it on a dashboard. What formula would I use to do that? I was doing some research but i just keep getting #UNPARSEABLE
What am I doing wrong?
Trying to count how many of a certain type of ticket was opened in a specific month. I have this to count the specific ticket type (which does work): =COUNT([Reference #]:[Reference #]) I have this to count all ticket opened in January (also works): =COUNTIF([Date Opened]:[Date Opened], IFERROR(MONTH(@cell ), 0) = 1) I…
What formula do I use for my needs?
I have 2 sheets (see screenshots) and what I need is to have the Associate Name from the Associate List sheet copied to a column in the Permissions sheet but only if certain criteria is meet. If there is a date in the Yard Access AND GTDR Expiration columns, I need the Associate name listed in the GTDR Certified column on…

Formulas and Functions

Discussion List

Help Article Resources