Formulas
Discussion List
- I work in a property mgt department and we've built a room inspection form. Our suites have rooms assignments based on the bedroom within the suite. The columns for the form are broken into sections o…
- I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BL…
- Hello, The Status Column has a dropdown menu with multiple options with the text "Completed" and some other options: Completed awaiting Signature Completed Reviewing Completed Approved Failed Inspecti…
- Hi, I have a sheet which has 1 column showing a document name, and another column for document revision number. I need to make a vlookup which returns the owner of the doc, based on the document name …
- Good morning, I have a contact column, then an email address column where I use a Vlookup function to go to another sheet and pull the users email address from. However, when I enter multiple contacts…
- Hello Community, I'm running into a bit of an issue. My previous worked fine for the year 2022 but now that we're in 2023 I need to adjust my formula to account for the year change. Below is the formu…
- Hi Smarties, I have a question on Index and Match formula. I am using the Project Management Office template set from Smartsheet. Based on the Intake sheet, a new project is created, and a number will…
- Hi all, I'm trying to use SUMIFS in Smartsheet to sum actual hours for individuals between two dates. I'm using two sheets, one is the front facing table and the other is the raw data. I've tried this…
- I am trying to find a way to count how many cells in my column have a date in it. I use the formula =COUNT([Target Launch Date]6:[Target Launch Date]24) but it always appears the error code #DATE EXPE…
- I have a sheet which is referencing another sheet. We would like to count the number or rows which have a date (on the referencing sheet) that falls between the start & finish date but the checkbox (o…
