Formulas and Functions

Archives for February 2021

Move Rows using iPad App
Is it possible to move rows to another sheet while using the iPad app? I cannot find a way to do so.
Trouble shooting a INDEX/MAX/Collect formula with an IF statement
So this is the weirdest thing - at least for me. The same formula works great for one column, but not for the other. It works fantastic here: =IF(COUNTIFS({DAX Ambient Inventory Range Install Date}, ISDATE(@cell), {DAX Ambient Inventory Project #}, [Project Number]@row) > 0, INDEX(MAX(COLLECT({DAX Ambient Inventory Range…
count value
I need a formula that will count cells in a column that have any value in them that is not zero
Countif date range and checkbox
I need to count all of the contracts won & lost by month. Similarly I need to sum all of the proposal budgets won/lost by month.Does someone have a formula that would work for this?
Formula
I want to include a column, On Hold, a checkbox (0,1). If it's checked, I want the State to be "On Hold", with another formula that enters State depending on two other cells - Status (RYGB) and % Column. Unchecked and it should follow the rest of the formula. How do I combine them? =IF([On Hold]@row = 1, "On Hold")…
IF Formula
I am trying to write an IF formula to convert a single select text option into a numerical value, but am receiving an #INVALIDOPERATION error message. Formula is below. Can you advise where I am going wrong? =IF({Level of Scrutiny} = "High", 2, IF({Level of Scrutiny} = "Moderate", 1, IF({Level of Scrutiny} = "Low", 0)))
Current User/Alert Someone Automation
Hi, I have an automation that any time a comment is made a contact listed gets an email using alert someone. The issue is the email links to the report but the report is so large it is difficult to then find the comment that was made. Is there a way to make the link or report more defined when they go to it? Or at least…
Pass/Fail status based on value of one cell being less than or greater than another cell
Hi All, Would appreciate some guidance on a formula I'm having trouble with. I would like to create a pass/fail column based on whether the value in a column@row is greater than or less than the value of another column@ row. Current Formula - =IF(CFUs@row > [Action Level CFU]@row, "Fail", "Pass") For some reason, I am…
Linking rows in reports/linking emails to sheet
Is there a way to link rows in your reports with other reports so I am not adding the same information on multiple reports? The way our sheet is set up is many columns with information gathered from various forms we created. I have a report set up for each form so I can access the information for the form quickly without…
Test workflow logic
How can I test the workflow logic if it is working? Is it possible to forced trigger the workflow?

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 のご利用を開始するために必要なすべてを網羅しています。
Smartsheet In Person User Group | Raleigh
Connect with fellow Smartsheet mobilizers and advocates! Join us at our in person user group in Raleigh, NC on Jan. 15. This is a great opportunity to discover how other local users are optimizing their use of Smartsheet. *Get inspired: We'll learn from local users, who will share success stories on how they use Smartsheet…

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

SUMIFS using Dropdown
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
Date format issued from date formula not recognized as date : message #DATE EXPECTED
Hello, I face one difficulty trying to transform text in date using DATE formula I want to find the first day of a week based on the week number & year number put in a cell For instance in a cell I find "25-45" FOR Year= 2025 & Week= 45, so I look for the monday of this week that should be the 3rd of nov Step 1 find first…
Date and Time Separator Formula
Hi Community, I'm looking for assistance with creating formulas in Smartsheet to separate a combined DateTime value into two distinct columns: one for the date and one for the time. "Date" Column: Contains both date and time values "Date Only" Column: Should display only the date "Time Only" Column: Should display only the…

Formulas and Functions

Discussion List

Help Article Resources