Formulas and Functions

Archives for October 2022

Health Check Using Nested IF with Various Criteria
Hello, I am trying to created a nested IF formula and stuck. A column was created for each color to help with validation. Originally, YELLOW was set at IF([Time Left]@row >= 3), but then both YELLOW and GRAY would highlight. Note: That any value would return a yellow ball that is greater than 3, even N/A. When the value is…
Formula to add days, adds years instead
Trying to add days to a date from another column on the same sheet, but it adds digits to the years format instead. Date Source = 08/12/22. Cell Formula =Date@row + 20 Expected Answer = 09/09/22. Actual Answer = 08/22/2220. Please assist and advise. Thanks.
Conditional Formatting Referencing Other Sheets
Hello, I'm building a process and want to add some automations to minimize errors. I have a column for "partner" that is a filled in via a form on sheet 1. I have a list of partners that we do not work with in sheet 2. I would like for the row (or cell) in sheet 1 to change colors if the form response is one of the names…
How to calculate difference of two sheets into a separate grid
I have data in four grids; a master (G1) and three data sets (G2, G3, G4). I need to return the data results of G2 minus G3 as a line item in G1 but will require a "vlookup" to do so. Separately, I need to know if there is a difference "Yes/No" between G4 and G3 on the same line but in a different column. I've included a…
Trying to only pull the month from a cell if the a certain drop box is picked
I am trying to count the amount of projects in a month with the date entered but only pull it out if a the drop down box says archived, I believe the month count is correct as that part alone works but when trying to add the code for the dropdown box it does not work, any help would be apricated, code below;…
Sheet Owner Name Auto-Populate in Cell
Is there a function to automatically pull in a Sheet Owner name into a cell? Thanks!
Cell linking
Hey, I want to link values from one sheet to another, but to keep 3 empty rows everytime between the linked cells. Is there a way to do that? Thank you very much
Cell History not available
Good day, We are noticing that cell history is not tracking on some of our smartsheets. Below is an example with deidentified data. Thanks Becky Menning
Return a date
I am sure this is simple, but I am relatively new to SS. I have 2 sheets, Sheet 1 is called FMS Columns are PN Sup FFM MTA Priority Promise Sheet 2 is called SS DATA Columns are PN DESC Need On SS ETA In sheet 2, I want to return a date only from sheet 1 that is in the promise column, when PN matches. And if there is no…
Formula or Automation?
Hi all Hope someone can help me please? Is there any way of counting how many times a cell on a row changes value? We have an "Installation Date" in our schedule for each job and we want to track how many times builders/clients change the installation date. I realise I will need a dedicated column to do this. Thank you in…

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

% Expected formula
How is best get % expected formula? I'd like to show for example that by original plan we should have completed 30% but actually have only completed 10%. I have separate column for % completed (reality) and added manually the % expected. Any tips? Thanks
Older than 3 years and Status set to Closed
I'm hoping I'm missing something obvious but, I haven't had luck doing this on my own so far and I'm hoping someone can help. I have a sheet I'd like to create a workflow on that when a status changes to 9 - Close Job as Complete and any of 3 date columns is older than 3 years to move the row to an archive sheet I set up.…
Stacked IF Statement Using AND and OR
I'm trying to write a formula that evaluates three columns of dates and pulls in the value of a fourth column (MWh@row) if each of the first three column's dates have already occurred in the past or will happen before the end of this year, and I'm not having any success. I keep getting an "#INCORRECT ARGUMENT" error. Can…

Formulas and Functions

Discussion List

Help Article Resources