-
2025 Free Smartsheet Webinars/Office Hours
I hope everyone is having a great start to their year! I am posting here because I wanted to share the schedule for the Smartsheet Webinars we will be hosting this year. Here’s a breakdown of the schedule for the first half of this year: Office Hours: Starting in February, our Customer Success Manager, Lisette Planken,…
-
Formula for numbering rows based on specific conditions
Hello! I need to create formulas for two columns that number rows based on specific conditions. I have a helper column (Number). First, I want to number rows that: Type is "Focus Group Volunteer" and Internal is "yes." Second, I want to number rows that: Type is "Focus Group Volunteer", Internal is "no", and Patron Type is…
-
Auto fill form for status updates
Hi, I am creating a form for our weekly status updates so we can see the history. However, it would be useful to have default values pre populated in the form from last week's update so the PMs can update it instead of writing it again - if applicable. This value needs to be pulled from a sheet based on the region/function…
-
Updating a Parent Row Based on Children's Status
Hello! We are trying to create a formula to accommodate the following logic: IF any [RFP Status] of children HAS In Progress or Canceled return the value "In Progress", IF ALL [RFP Status] of children HAS Complete or Canceled return the value "Complete", Otherwise, Not Started. I generated the formula below using AI,…
-
Index match with Left
I'm trying to make an Index/Match formula and I can use some help. I have a Smartsheet with a list of parts (Sheet1). I also have a Smartsheet that has a list of part prefixes and a contact for parts beginning with that prefix (Sheet2). I would like to do an Index match on my parts smarsheet (sheet1) so that any parts…
-
Formula that will look at how many submissions there have been by group in the last 7 days
I am trying to figure out how to pull the data from a different sheet to build my roll up and dashboard. I am trying to use the following formula. The goal is to be able to show how many submissions there were last week for each group. =COUNTIFS({JHA Tracker with Form Range 66}, @cell <=TODAY()), ({JHA Tracker with Form…
-
Please add a Wildcard Function
Smartsheet is missing the ability to use a wildcard (*) in it's functions. This is a valuable tool and would be incredibly helpful, please add this functionality.
-
Snapshot of Smartsheet comparing TODAY to Start and End Dates
I have a grid sheet full of contracts: each row is a contract. Each row has a START DATE and END DATE along with other details about the contract. I was tasked with creating a dashboard to represent this grid sheet over time. I am now creating a reference sheet to pull "snap-shots" of data from the grid sheet. I put in a…
-
Add the ability to enter simple formulas into cells in a Report View
I've got a Report View that simplifies what columns & rows are displayed out of the full sheet so that a user can input data on a weekly basis. We recently are facing a scenario where we need to sum up multiple values into a single cell. Although the math isn't 'hard' it is more efficient to simply type in i.e., '=123+456'…
-
Index/Match vs Index/Collect vs Index/Contains
Creating a sheet to collect and answer FAQs, I am attempting to populate the System/Tech Supporting SME dependent upon the selected system/technology. I have my primary collection sheet and then I have made a reference sheet for some formulas. Relevant columns with fake data from the primary collection sheet. System/Tech…
