Formulas and Functions

Archives for June 2023

Auto share data with other smartsheets
Does anyone know if I can share data with another smartsheet? There are 4 departments tracking different parts of the same data. Is there a way to automatically share that data with a main smartsheet? Excell can auto populate/auto update cells in a separate excel document, can smartsheets do that?
Formula for counting Invites and number of guests associated with that invite
Hello, this is a fairly easy one, but I am stumped so wanted to see if anyone could help. I have a list of people I am inviting to an event. Some invites have 1 total invite and some invites have 2 total invites. I have a column for a count to specify whether it's 1 or 2 invites going out and then a column that says "Yes"…
Multi-part formula with multi select field using references issue
Hello- I am trying to write a formula that includes sheet references, and two conditions. I need to count the number of students in each category and how many of those students chose a specific availability time from a multi-select drop-down menu. This is what I came up with but doesn't work. =COUNTIFS({Student Type},…
Formula for Revenue by week and month
Im trying to determine the revenue by week and by month using the completed date field
Count Project Question
Good afternoon, We have various different 'centers of excellence' that our team supports for projects. Some projects may be overlapping between the centers of excellence, while others may just be specific to one singular center of excellence. Overall, we have 26 projects altogether being worked between the different…
How to make a manual Row ID based on conditions?
I'm not even sure if this is possible but I invite all the formula wizards to take a crack at it! I have this intake sheet with 10 rows, all that have a corresponding auto-generated Row ID from the system column. Row 1 is 23-001, row 2 is 23-002, row 3 is 23-003, etc. When a project gets approved, I want another column,…
Return a line item that is a past due order?
I have a list of orders with an "Estimated Receive Date" and an "Arrived" date. I want to return the PO number if the received date is blank and the estimated received date is less than today. What formula can I use for this?
COUNTIF Formula
How do I add to this formula to only capture 2023Q1, 2023Q2 completed- prioritized projects? I am currently using the formula below, but its capturing all of the completed- prioritized projects from other years. =COUNTIFS({MH-Work Prioritization Log Range 1}, "Completed- Prioritized") I also would like a formula to count…
Is there a formula or other way to have a column display the date that a checkbox was checked?
Is There A Formula or Other Way to have a column display the date that a checkbox was checked? I'm also wondering if the user who checked the box could also be displayed in a column?
Check if project start/end dates fall within specific time frame.
My team works on projects that typically take 6-12 months. I'd like to create a roll-up sheet that identifies which quarters in which a project was worked on. I'm creating a new row for each project and linking in the start and end dates from each of the projects' sheets. Then I've created a new column for each quarter…

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

Is there a way to break out found Rows from a LInked Sheet into sequential rows in a new sheet?
Hi folks. Let's say I have a sheet with the following data: Then I make a second sheet that links to the first, looking for matches of both the Name and Date. What I want, in this second sheet, is to eventually show that on 12/25, Matt is Eating a Sandwich (first row of new sheet) and Using the Toilet (second row of new…
Duration based on time - formula question
I was able to create a Smartsheet column with time included with the date (Thank you @Paul Newcome & @Akblevins ). I want to add another column that just shows the time - I used the AI Smartsheet feature to create a formula but receive an error message. Any ideas on how to correct? TIA!
Help with a formula or formuals
I have 3 columns: Vic By plate number and model, Date Driven(Date Field), and mileage. I am trying to fina a formula or formuals to allow me to see the difference in milage since the last time the plate number has driven. Bonus: In 1 month. Trying to find an easy way to see priority of which vehicle needs to be driven next…

Formulas and Functions

Discussion List

Help Article Resources