-
Advanced Formula #No Match Error
Hello, I have a master sheet that I am referencing which contains multiples rows that I need reflected on my teams sheet. There is a column named "Vuln Mgmt" (set as a dropdown/multi-select) that has options Yes: 3rd party, Yes: Security, or No. I want to create a formula that will reference the entire master sheet and…
-
Ignore blank cells in concatenation
I want to concatenate multiple columns data in a cell but would like to add a condition to ignore blank cells, I used a "|" to identify two different data's but if there is any blank cells "|" this symbol is keep adding without any data in between, =Product@row + " " + Variant@row + "|" + [Product 0]@row + " " + [Variant…
-
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…
