-
Nested If And Not Formula
Hi all, I'm working to write a formula that displays a health ball (R,Y,G,B) that's based on a variety of logical expressions. Below is what I am aiming to achieve. Status@row = Complete, then Green Status@row = On Hold, then Blue Finish@row = Blank, then Blank Here is where it gets tricky... If Finish is less than today…
-
Stuck on IF/AND formula
Hi I am using the Summary area and trying to create a formula that will show me when my Finish date is greater than today's date AND the status is not "complete" then say Overdue and if false say None Overdue. I have messed around with this for half a day (and other related items) and I am too frustrated to try anymore so…
-
Formulas- Equivalent of an array?
Hello! I am trying to write a formula that pulls information from one sheet into another based on a criteria. I have successfully written the formula to work for a single row, but can not get it to repeat for successive rows. I believe I'm looking for Smartsheet's equivalent to an array. I understand that a cell range is…
-
Purchase calculation from the grant amount
I'm maintaining a separate sheet to maintain the purchaser grant and I used index match formula to auto populate based on the purchaser grant ID, Now I want to minus total price from the grant and show the remaining grant when I do the second purchase with the same purchaser grant ID I should automatically get the…
-
IF(OR( formulas
Hi there, I reached an impasse with IF(OR( formula. I've 3 columns named as below : STATUS INMETEN / STATUS MODEL / Step 1 - Gescande Club In each column, I've several data filled in. I wrote the following fucntion : IF(OR([STATUS INMETEN]@row = "Inmeten afgerond", [STATUS INMETEN]@row = "2 - Pointcloud", [STATUS…
-
Count the number of lines, based on the creation date column
Hi, Can anyone help me with the formula? I have a sheet with approx 400 lines of which the creation date is automatically generated. I would like to count how many lines were created in the year of 2020, 2021 and 2022 based on that column. Thank you for helping me out!
-
Automate Cell Linking??
I have an smartsheet "employee table" that contains employee names and employee IDs. I also have a smartsheet "activity" that logs employee activity via a smartsheet form. The goal is to pull the employee ID from the the "employee table" smartsheet and copy / input it into the Employee ID column of the "activity"…
-
How to use a smartsheet to update the form dropdown values in another smartsheet?
I have a smartsheet that contains employee names and employee IDs. I would like to use the employee names stored in this sheet to update a form dropdown list of employee names on a separate smartsheet that tracks employee activity. I was going to use data shuttle, however there is not an upload data from a smartsheet…
-
Insert "Or" Statement in a INDEX(COLLECT), CONTAINS
Hi Team, I need to insert an OR statement into the following formula. I would like to modify the formula to find one of two values, whichever it finds, populate. The current statement: =INDEX(COLLECT({Interface Raw Data Range 1}, {Interface Raw Data Range 1}, CONTAINS([Interface Name]@row, @cell)), 1) - ***This formula…
-
COUNTIF and CONTAINS for a *multiselect* Contacts column?
Hi -- does anyone know if it's possible to use the combo COUNTIF & CONTAINS on a multiselect contacts column? Use case: we have projects that involve multiple resources, which we've captured as a multiselect contacts column. I'd like to report on how many projects each resource has, which means I need a count of all of the…
