-
Look up Contacts from Cell on Sheet
I've got a bank download that has a user name in "Last, First" format and I'd like to look up the Contact so I can e-mail the data to that contact. Any suggestions? Appreciate it! Brent
-
Revise current formula to add IF Statement
Hello again! First, thanks for looking, and thanks even more for potentially helping, it is greatly appreciated. Okay, first, I have a working formula (wooohooo)! Okay, I now need an additional IF Statement added to my current formula, and this is where it gets tricky. The first screenshot is where my formula will go. The…
-
IF formula , with item found on another sheet
Hi, I am trying to create a formula. i want to return a patient's status based on if that patient is found on another sheet. I have 2 sheets list of active patients available cases 7.6 I have a an admission ID on both sheets which can be used in a vlookup type of formula. if the admission ID is found on the "available…
-
Need Help with Formula, want all project summary sheet to record most recent step completed
Hi I have a summary sheet that contains all projects that my various PM are working on, the project summary sheet looks like this: Each project then has its own sheet for the PMs to keep track of what steps have been completed for the project, looks like this: On the summary sheet in the "most recent step completed" column…
-
IF THEN formula
I'm trying to incorporate a formula in one of my sheets. I'm going to use terms as if I were referring to Excel since I'm still getting familiar with the terms in Smartsheet. For example, if cell A2 contains a date but cell B2 doesn't have a date then I want the value in cell C2 to return "50%". If cell B2 contains a date…
-
How can I connect multiple sheets into 1 master sheet?
I have multiple sheets, each populated by their own form. I would like each sheet's columns imported into the master sheet and populate the same row. Is that possible?
-
Automate the Progress Bar
Hi there Smartsheet Guru's! Im trying to figure out the best way to automate a progress bar, based of 9 columns that all have check boxes. Screenshot shown:
-
Formulas for highlight the difference
I'm new and it would be great if I had help. I would like to know the formula that must be put in a cell to highlight if there is an equality or not between 2 values (see screenshots). I need to do it to highlight the differences during an inventory and highlight them (with the conditional form like "if this is False…
-
How to extract the data from the another sheet?
I am trying to find out the formula that help me to list out how many trading partners that we are currently working on it. The list should not be duplicated and it will be Renault, Titan X, Volvo. Can someone please help me?
-
Collect function feature add multiple columns
When using the Collect function inside the Index function a user must select a range of only 1 column or the error #INCORRECT ARGUEMENT SET is returned. This also means that the row_index of the Index function must also always be 1 as the Collect function is limited to return a single value (as opposed to an array of…
