Formulas
Discussion List
- I created a formula to populate a field based on the status of various other fields. I got it to work with two conditions (Approved or Declined), but when I add the third (Submitted) with the false re…
- I'm looking to average the click through rates (CTR) by type of ad for 2023 in the SmartSheet Summary Sheet section. There is data from 2022 and 2024 on my sheet, so I'm trying to make sure the data i…
- Hi, I have a column with colored health status of some project tasks, due to the fact in email updates and that you cannot see the colored got in the email, I am hoping to add a column that with align…
- Hi fellows, I've a Destination sheet (SHEET 1) and a Source sheet (SHEET 2). In SHEET 1 i've set the following INDEX/MATCH formula for all the cells in col. B: =INDEX({SHEET 2-Col. B}, MATCH(SHEET1-Co…
- Hi there! We have a smartsheet that is for program enrollment. The program start date is the first day of the following month after the enrollee's start date (so, if they start on 11.15 in their offic…
- Hello everyone, I am trying to create a table in which the first row has the week-end dates (week ending Friday), instead of putting the dates manually, is there any formula I can use? Please note tha…
- For project resource hours that I am trying to tally I am trying to look across multiple date columns, locating all the dates for a specific month, and then based on that, tally the total number of ho…
- Hi there, I need assistance with formatting this formula: =COUNTIFS({Program Name}, (@cell), {Program Name}, [Program Name]@row)) My goal is to count the number of attendees per program session in our…
- Getting started in Smartsheets for Project Management. I've been reading a number of Q/A on creating formulas to flag At Risk. I want to flag any task 3 days before the End Date or if it's past the En…
- Hey there, I am trying to create a top 5 list of values from a large table of information. the idea is that you would be able to see which "ATA Chapters" have the highest figure next to them, for exam…
