-
Using If formula with symbols
Hi there, Trying to create a formula using symbols, but am getting the #UNPARSEABLE message. Under my Progress column, I'm using symbols (Red, Green, Yellow and Blue). For the Value if true: if the symbol is green, then I want the number that is entered into the column titled "Run Time" to be populated into "Column 12".…
-
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
-
Combine Index Match with SumIFS (Multiple Criteria)
Hello, I am having trouble figuring out how to calculate a sum if multiple criteria are met. I am referencing data between two sheets. I want to test if there is a match for two criteria in 'Sheet 1' (Project Number and Labor Code) against those same criteria in 'Sheet 2'. If both criteria are met, I would like to sum all…
-
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…
-
Anyone who has an alternative formula for this?
I need the Target % to date column to sum up the values of each activity based on week no (red font). For now i use this formula (see sample data below) as interim solution, problem is the formula will reach the limit if i have more than 30 weeks (usually we set 100weeks in projects). Thanks you in advance! spipmo
-
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…
-
I need to calculate the number of working days a task has been assigned, if not closed or canceled
Below is what I have tried but it does not work. =IF(Status@row = "Closed", ()), IF(Status@row = "Canceled", ()),NETWORKDAYS([Date Assigned]@row, TODAY())
-
Is there a way to pull information from a cell and have it request information from a website?
Hi! I have what I feel might be a stupid question, but I am trying to automate as much of my process in Smartsheets as possible so any help would be fantastic! I have our team entering information into a form including email domains. Is there a way for Smartsheets to take the email domain from a cell and send the…
-
Join Multiple Data Sheets into a report to control attachments visible to different vendors
I have a master project datasheet where each row represents a project. I have built various reports for vendors involved to make sure the appropriate vendor only sees the appropriate rows and data fields. Each row has multiple vendors involved. I would like to add similar control for attachments, but ensure only the…
