-
Locking cells in sheet
Hello, I am trying to determine if there is a way to lock the formulas I have placed in my sheet so that the users cannot override them to hard key in numbers. The formulas have been entered into all of the necessary cells but as it stands, users can simply clear them out to enter the amounts in their own way. We have…
-
Getting #incorrect argument on IF formula
Help! I had this working then deleted the test lines and it deleted the formula also. Can anyone tell me what I'm missing here? =IF([Request Type]@row = "D&E Contract Signed", ([D&E Amount]@row * 0.3), IF([Request Type]@row = "Project Contract Signed", ([Estimated/Final Project Total]@row * [Estimated/Final Margin]@row *…
-
How to determine if a row id is in the list of predecessors for any row
Hello, I have a fairly large Project plan with 700+ rows and am new to Smartsheet. My predecessors list for any given task has multiple row IDs referenced (comma delimited) With help from Rob Hagan's post (https://community.smartsheet.com/discussion/formula-determine-row-number), I have created the ROW_ID) column for…
-
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,…