Formulas and Functions

Archives for May 2022

COUNTIFS problem
I am trying to populate time est. cant seem to get the formula right. I am sure HAS got something to do with it.
Three value RGB fomula?
So I have a template that I have adapted and it had a base formula for project health based on the difference in the planned date and the actual date. The issue is that it does not link to todays date so if you dont change the actual date it looks green even if it is days late. On the flip side if something is way late,…
So close... help please - IF AND NOT ISBLANK two columns to a results column
Hello Community! I am close on this but I just cannot figure out this last piece and it is driving me nuts. I have two date columns and depending which columns have values I need to record a value in a third column from one of those columns. I have it working with a one column scenario either way but I cannot get the AND…
Summing rows if columns are checked using cross-sheet reference
Hello, This is the formula I've tried but it is giving me an "unparseable" error. =SUMIF({Tracer Site List -Revenue/Project Complete},[Project Complete]:[Project Complete], 1, [Licensing Fee]:[Licensing Fee]) Thank you for your assistance!
Recent Submission Formula
Hello, My goal is to create a formula that will automatically update the current status of our utility systems based on the submission of the most recent inspection form. Basically, I'm looking to create a green dot on a separate sheet if ARU1 and ARU2 are both online and both temperatures are in spec (I can provide the…
Links connecting one sheet to another are not working - how can I resolve this?
Links between sheets are not working. I've seen status updates on this from people in the past, but am not sure if this is an ongoing issue or if it has been resolved. If I need to submit a ticket to SmartSheet, please advise or advise how I might be able to fix this myself. Thanks!
Absolute reference for parent cell
Hello, I want to write a formula to copy over the parent row name to the whole column of the group of cells. When I start a new project within the sheet, I want the column to change to what the project name is. Below is a snip of what I would like the formula to do. Thanks!
Auto scheduling tasks/recurring tasks NOT WORKFLOW!
I can see "recurring tasks" has been asked for by the community for years, but I can't see it has ever been developed, I'm hoping it has and I just can't find it. I want to be able to automate the following: A bi-monthly task that must take place 2 months after the previous task, so that if task one gets moved, all…
Duration v actual time
Is there a way to add a task that might be 4 days over a one month period, for example. So I don't have to create a separate task for every time that task happens, I just want to show a task that runs from 1 May to 30 May but takes 4 days to complete? I have considered different options, including changing the appearance…
Capture name of last associate to edit / close out a line
Hello, I need to know who worked a specific line in Smartsheet. I currently am using the "modify by" column type and a drop down list column with names. They both seem to be unreliable because the "modify by" column type changes when the line moves from the working sheet to the archive sheet and the drop down list column…

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 keeps returning 0
I'm trying to display a sum of the column Total Funds Available when Status = Apps Open, and Value Score = 5. Here is the formula I have: =SUMIFS([Total Funds Available]:[Total Funds Available], Status:Status, ="Apps Open", [Value Score]:[Value Score], ="5") There are rows that meet these conditions and should display a…
Issues with IF formula
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
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…

Formulas and Functions

Discussion List

Help Article Resources