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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

How to count a field which has a certain character in it.
I have a field with the date formatted as 09/30/2024. I would like to summarize that field with the count of lines containing 09 and 2024 (so basically by the month and year). I am attempting just for the month and can not get it to work. =COUNTIFS([Next Renewal Date]:[Next Renewal Date], CONTAINS("09") But I would also…
Get a Countif on values in a multi-select column of cells
I am trying to write summary formulas to determine how many values appear of each in the drop-down of a column. I tried adding a wildcard, I have tried HAS, and tried CONTAIN, but I'm still not getting the right values. Currently I am getting 0 as a return value on this formula: =COUNTIF([ROI Type]:[ROI Type], HAS([ROI…
summaries in report
Hi i'm trying to build a report with summaries options. i have two column that i want a Min and Max summary. the column for the Min i a texte column and works well. but the other column has formulas and the Max doesn't works. there is a way to fix that? (instead of creating another text column in the source sheets?) here…

Formulas and Functions

Discussion List

Help Article Resources