Formulas
Discussion List
- I have 5 large sheets (10,000 rows, 45 columns) mostly populated by DataTable that I'm collecting metrics from on separate metric sheets (1 DT sheet → 1 metric sheet). The metric sheets collect the me…
- I'm trying to pull in hours to what I'll call Sheet 1 from Sheet 2. I have flexibility in the way I set up Sheet 2, but I need Sheet 2 to be able to have various employees use the same project number.…
- Hi, New to Smartsheet and hitting a roadblock in one of my formulas. I have two sheets: Projects and Resources. On the Projects sheet I collect resource groups that will work on a project. Each projec…
- I am trying to get a count of trainees in my app, each trainee has a unique "Member ID". A trainee is defined as meeting one or more of the following criteria: has a value of "Submitted" or "Issued" i…
- Hello! I am stuck - trying to leverage a sheet summary field to sum a total, where one of the columns has two conditions that I want to exclude from the Sum. I can get one of them to work: =SUMIFS([Am…
- I am trying to write what seems like a basic formula, but I'm not getting the expected result. I would like to reference a Contact Cell column with an If(Contains) formula. The basic formula I have wr…
- Hello, I have a metrics sheet that is referencing another sheet to count how many counts of a specific Hold/MECQI Reason =COUNTIFS({Hold/MECQI Reason}, CONTAINS("incorrect container", @cell), {Hold Is…
- Hi, This formula causes a #unparseable and can't figure out what is wrong: =IF(Description@row = "Overall Project Risk", "0-00", IF([RAID Type]@row = "", "", IF(Status@row = "Complete", 7, IF([RAID Ty…
- Based on what I read about HAS Function in the Formula Basics (HAS Function | Smartsheet Learning Center) I should be able to use HAS with COUNTIFS. When I try to use it in a sheet, I receive the erro…
- I am trying to get a CountIFS formula to work that includes three sheet references and I get errors no matter what I do. I am trying to count the number of tasks with the isParent checkbox not checked…