Formulas and Functions

Archives for July 2018

Stock sheet automatic email when stock drops below an amount....
Hi everyone, We're putting together a stock sheet and we want to create notifications so that when a figure in a cell drops below a certain amount an email is automatically sent to the relevant people so they know to re-order. Can anyone help please? Many thanks!
Traffic light formula
Hi, I have a traffic light column in spreadsheet and I have a formula that triggers the colour based on a status column. I am just looking to add a step in that turns the traffic light red if it is not started or in progress and it is past the due date Formula so far =IF(Status210 = "Completed", "Green", IF(Status210 = "In…
Setting up automatic reminder system
Hello community, I have a tricky question here concerning how to send out a reminder automatically based on the following idea. I have a sheet which lists the status of certain rows. Each row has a column that indicates with Green/Yellow/Red/Gray dots (symbols) - these indicate if an item has been fixed, pending, still…
f(x) & Edit Reference do not appear
The help documentation states the following about cell references: “You can edit the name, referenced cell range, and source sheet of the reference.” If using a long formula and selecting the cell containing the formula, the left-most portion of the formula is not visible on the display (i.e., f(x) = AND Edit Reference do…
Reporting Using Parent Child Relationships
Hello - I have created a report to display the current user's list of high level milestones. This list is supposed to display any milestone that is blank under parent child relationship. This ensures only high level tasks are displayed. Its seems to work fairly well, but I have encountered one issue. For one of my sheets…
Project Management, If then Statements
Hi, I was wondering about Project Management using Smartsheet. I am trying to create a project where there are many options or collateral pieces that key stakeholders can request from our marketing team based upon the amount of ROI projected and what they rank. E.G. Gold= anticipated $$$ Silver = $$ and Copper = $ If they…
Countifs formula error
within the same report as my list of projects I'm trying to return a count of projects that are due to start within the current week (day 0 - 7) from "today" then return a count of project for next week from (day 8 - 13) then week 3 (day 14 - 20). here's the formula I came up with but it's not working.…
Count time between dates in Weeks/Days
How would I calculate the time between two dates (start and finish) in Weeks and Days "8weeks 4days"
IF/AND Formula with Dates
I get a #UNPARSEABLE error on his formula. [Permit Agency Approved] is a date only column [Permit Agency Approved (F)] is a date only column =IF(AND(ISBLANK([Permit Agency Approved]9)), [Permit Agency Approved (F)]9 < TODAY, "Review","None") What I would like to accomplish is, If the [Permit Agency Approved] column is…
Dashboard showing status of symbols
Hello community, I apologize if this comes across as trivial, but I am wondering what the optimal solution is to show charts (pie, mostly) showing what percentage of cells in a sheet have the symbol Red Dot / Green Dot / etc. Can I access those symbols directly? Or can I do some sort of IF statement which assigns a value…

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

Flag projects at risk
Hi community experts, I'm trying to flag projects that are at risk. A project should be marked "At Risk" if the Status is not Complete, the Due Date is within the next 7 days, and the % Complete is less than 80%. Otherwise it should show On Track. What formula can do this?
Bring data from source sheet in to separate columns in data sheet
I have a source sheet with >250 rows with each row having a unique [Criteria]. We assign [Status] and [Approval] status to each row that changes in a regular basis. Demo of source sheet: Given the number of rows, I would like to improve visibility of the changing status's in new sheet that will bring in the [Criteria] and…
Health Indicator Claculation
I Am using the below formular in my Health Indicator but even though my project is on track My overall project indicator is showing Red. What have I done wrong any assistance please :-) =IF(AND([End Date]@row < TODAY(), [% Complete]@row < 1), "Red", IF(AND([Start Date]@row <= TODAY(), [End Date]@row >= TODAY(1), (TODAY(1)…

Formulas and Functions

Discussion List

Help Article Resources