-
Sheet reference returns #UNPARSEABLE
Hello, I repurposed a working formula to a new sheet and changed the formula to reference another sheet to meet the second conditional criteria of the formula. For some reason the edited formula is not working as expected, I keep getting UPARSEABLE returned. Working formula =IF([1st Claim Recvd in Months]@row <= 12, [PO…
-
Evaluate entire column for matching values
Hi! I've tried a few ways but don't seem to be successful. I need to evaluate an entire column of data for the same values. So for instance, I need to evaluate Column A for all the same Agency Names. In instances where the Agency Name matches I need to then evaluate a 2nd column for matching titles. If both match.. input a…
-
Nested IF OR limits?
I have some very involved nested IF(OR( formulas in my sheet. They all work past the initial IF, and the the first IF(OR( statement, then ignores everything past that one. I'm hoping it's just a syntax issue vs a limitation. Here's one example: =IF([Outsource Due Date]@row = "", IF([Route Number]@row = "FAB-WELD-NOFIN-09",…
-
#DIVIDE BY ZERO issue - AVG formula
Hello Smartsheet Community, Working on a Formula to record the Average column value (numeric # of days) by a month value in another Cell (01/15/22) in same Row. For trend analysis, ideally would like to show by each Month (Jan – Dec) an Average of #’s in a column if within the same row a Date column is posted.…
-
Modifying column formula based on criteria of other columns?
Hi all, Is there a way to modify a column formula based on criteria of other columns? For example, if a column is checked, to use a specific date rather than the date listed? My goal is to create a formula that defaults to the 15th of the month IF a certain box is checked YES. Thanks!
-
Streamline my Formula
Hello everyone, Im currently using a very tedious process of finding the number that I need from this sheet. It is a pasted excel sheet into a Smartsheet. There are multiple repeating "CC Codes" that are only differentiated by the "111" number in the Primary Column. I need to find the value for each of these items on…
-
Formula Error
Hello, I was hoping to get some help with a formula. We are using INDEX/MATCH. Its all working great when we are referencing one column. When we change the reference to select a range of columns, the formula doesn't work and we get #UNPERISHABLE. Can someone help us figure out how to reference a range of columns? Here is…
-
Multiple conditions IFERROR statement with RANKEQ
Hi all, I'm trying to make a modification to an IFERROR statement which is the following: =IFERROR(RANKEQ([Weighted Project Score]@row, [Weighted Project Score]:[Weighted Project Score], 0), "Not Ranked") This essentially runs a RANKEQ on all the entries, but if there's a score of 0 it returns value of "Not Ranked". I am…
-
Do we have a way to reference column names yet?
I'd like to be able to write robust lookups which don't rely on a fixed column reference to return from a cross-sheet link. For example, I'd like to do a lookup on a row value (@row) in "ID Number" and bring back the value from another sheet e.g. "Project Name" where the ID number matches BUT specify that I want to…
-
Adding text to a field, then changing text color based on calculated values
Hello. I would like to ask if anyone has had an opportunity to have text added to a column, then based on a calculated value, change the text color from say black to red based on a calculated outcome. For example. I have a checkbox that simply determines if multiple Techs were required for a specific task. If the checkbox…