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

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

Check box for start date and end date that fall within Today's date
Hi Community I have a check box column with a column formula to check if the Start Date and End Date are Todays Date. =IF(AND(ISDATE([Start Date]@row ), ISDATE([End Date]@row ), [Start Date]@row <= TODAY(), [End Date]@row >= TODAY()), 1, 0) This works when there is a date range, ie Start Date is 18/2/26 and End Date is…
Converting Drop-down Date to a Date formatted value
First off, I am using Control Center to build out projects that are dependent on a central worksheet, "Weeks of…" as a drop-down source list. The "Weeks of…" is contained in a Portfolio folder in the Admin workspace. Secondly, I have a worksheet, "Weeks" that contains a number of dates, DATE. In this worksheet I have an…
Formula help - advanced logic
Please see formula below - when the planned date is less than the due date and inside the same month it shows as 'N/A'…. when the planned date is greater than either the actual day/date or the month in the due date of next inspection column it shows as 'Yes' in late booking column - when the planned date is less than the…

Formulas and Functions

Discussion List

Help Article Resources