Formulas and Functions

Archives for March 2018

IF statement formula needing help
I'm needing help completing a formula. The formula that is needed will look specific data in column "A" then specific data in column "B" with the result of these to coming from a different little grid. I've got the 1st (A & B) correct but can't seem to get the 3rd criteria to pull correctly. =IF(ISBLANK([column 1]3:[column…
RYG Automation based on "overall Score" Column
We do a customer follow up for every job we do. We ask 3 questions rated 1-10. If "Overall Score" column totals 26-30 points - green ball 20-25 points - yellow ball >20 points red ball. I can get the column to automatically put the word of the colour in, but not the actual ball. Is there a formula for such a thing? Thanks…
COUNTIFS Question
I'm having an issue understanding COUNTIFS in my scenario. I'm trying to track billable hours, and I'd like to summarize the hours value listed if another column equals a specific value. So I can track how many hours go to which projects. I believe COUNTIFS is the right formula to use, but not sure how to apply it. Any…
Sheet Name within a Cell
Hello, I was wondering if it is possible to write the current SS Sheet name to a cell that you are working on? The reason that i am checking this functionality is due to how certain project plans are created within a Workspace and i need to filter out within a report. Thanks, Anthony
COUNTIF FORMULA ERROR
Hi all, I'm fairly new to Smarthsheet and have run into a simple COUNTIF formula error. I want to simply sum all cells in a column that contain the text "*C-000*". My formula is below and I don't show an error in the formula but I also have zero results where I should be showing a sum total of at least 26.…
Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…
Date Formula
Hi I am trying to count the number of items that are for a particular month and year. eg: I would like to count the number of items submitted for the month of Jan 2018 the column I am wanting to pull the data from is a date column
Formula Counting Courses Required /Taken
All, Have a smartsheet that shows by student (each row is a student) what course they are required to take. The student updates the date they completed the course via update requests. Based on this smartsheet I am trying to find a formula that will show me when they have completed all courses that they are required. The…
IF, AND, OR Functions
So i have two formulas , one works and one does not; hoping someone can see what i am missing here. i have four columns that i need to take into consideration before i automatically check a checkbox . using two of the conditions works; i add the third in the second example and it blows up. thanks in advance: works:…
Resource Assignment based on a Vlookup?
I am creating templates for repeatable "projects." I would like to have a column of "Role Assigned" and set up a table (filled in when the template is used) that associates a specific person (Contact) with each role. Then in each row, a Vlookup would be used to automatically fill in the "Assigned To" contact name from the…

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

IF Formula Not Working As Intended
Hi everyone! The below formula is not populating a 0 in cells that are new, as intended. The AI tool even says this formula should work, but it's not. After staring at it for hours, I can't figure out where I'm going wrong. Your help would be greatly appreciated!! Thanks! :) =IFERROR([Date Logged]@row - MAX(COLLECT([Date…
JOIN + ACCOUNTING
Hello, SmartFam! I'm trying to join text with accounting numbers. but the join will not keep the financial formatting (removing the $ and correct , placements) Can you please help me get this right? VENDOR AMOUNT JOIN RESULT DESIRED RESULT AMAZON $435,678.90 AMAZON - 435678.90 AMAZON - $435,678.90
Unable to Count Blank/Empty Cells in a Column
I'm trying to count open/active events that have not been Resolved. Each event is on a separate row with a column called Resolved. Resolved Cells will either be empty/blank or contain a date & time as alphanumeric free text. Example below shows date on top of time in cell (I forced with ALT Enter after date) 3DEC 0859 ET…

Formulas and Functions

Discussion List

Help Article Resources