-
Vlookup / @row usage
In the Vlookup formula, Category@row references 4 contiguous columns to obtain one value, I added a 5th column and Category@row does not recognize the 5th column. How do I redefine Category@row to use the 5th column ? VLOOKUP(Category@row, {GL Account X Ref Range 4}, 2, false) Thanks for your help! Amy
-
Value count in multi-select column
Does anyone know if on a multi-select column there's a way to count if I only have a single value selected. For example, Based on the data in the "Platform" snapshot, I want to get the counts for second snapshot. Where I'm having the challenge is returning a value for the cells with single value selected that it's not also…
-
Need help count if formula with multiple criteria.
Need a little help with this one please. I think the blank cell part is stumping me. So I need to count the # of events an employee managed by event type within a date range (for the whole month) and that have not been cancelled. I have a column for cancellations. The cell is blank if it was NOT cancelled. If it was…
-
Control Center & Cross-Sheet References
Hello all, This is my first attempt at SCC provisioning of sheets and I ran into my first problem. There are three sheets in the blueprint -> Sheets A1, A2, & B. B pulls in data from sheet A1 and A2 via cross sheet references (index/match so I can reference by a key value in case rows move around in A1 and/or A2). When I…
-
Help! Refrence using =INDEX in a drop-down single select
Hi All, I'm new to Smartsheet, id like to use =INDEX formular reference to reference another sheet cell. when i select a single option in the drop down it will reference that cell.
-
Copy Date from Formula to another Sheet not working
Hello- I have one sheet with a Form attached. When users submit their form, I have a formula that will convert their some of their selections into start and end dates. Sheet 1 I then have a second sheet where all rows are copied from the first sheet that serves as a Calendar view for the created dates. I did this because I…
-
Can a checkbox in one sheet be auto-checked based on a checked checkbox in another sheet?
Hi all! Can a checkbox in one sheet be auto-checked based on a checked checkbox in another sheet? I've looked through multiple help resources but can't seem to find a situation that specifically matches my set-up. Here's what I'm looking to do: If the same Product Code exists in columns 1A and 1B, AND column 2A is checked,…
-
Search and Replace in formulas
When importing from Excel I need to fix some of the formulas. This would be easy if I could use a search and replace within all the formulas on the sheet in one go as you can in Excel. Does anyone know if there is a way to do this in Smartsheets?
-
Changing value in cell
Hi All, I am new to Smartsheet so any help is appreciated. Currently trying to use multiple sheets/forms to record inventory by scanning a basic barcode. I have setup form entries to be duplicated in another sheet but the value of the barcode in numbers (ie: 407621031) needs to be recorded as the item name. For example, I…
-
Countifs & NOT formula help
Ok so I want to count if the following criterias are met: BDM Column {cdatBDM}= BDM@row (BDM2) Date Column {DateCDAT}<= Todate@row (To1) However, I do not want it to count Category Column {Category} if it says "Portfolio" I tried the following to no success: - =COUNTIFS({Category}, NOT({Category} = "Portfolio"), {cdatBDM},…
