Formulas
Discussion List
- 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
- 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 Sta…
- 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 adm…
- 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…
- 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 c…
- 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?
- 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:
- 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…
- 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. Ca…
- 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…
