I'm looking for some help with an IF formula to assign a text value in one column based on a score range from a different column.
Thank you in advance for helping me figure out how to write this so that it works in the Smartsheet.
@Lisa Matthews2 ,
#UNPARSEABLE is most frequently caused by an imbalance in your ( and ). Try removing one ) from your formula and see if this fixes the error. Also keep in mind on nested IF statements that it will stop looking to solve when it hits the first TRUE in the conditionals. Your current nesting seems to be correct and works in my testing.
Thank you, @Malaina Hudson
That fixed the problem!! Extra parentheses was the problem.
@Lisa Matthews2 Great! Glad that helped!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
Hey All! Currently, I have a formula that if it is the Parent row (helper column shows 0) then Index multiple sheets using the SSI column. If it is a children row, use the parent SSI column to Index multiple sheets (pulling the same result). The only issue is if I have a child within a child, then the PARENT(SSI@row) no…
I am trying to write a formula based on two sheets. One sheet, Team Members, that has the following columns: Column 1 - Region Column 2 - Industry Column 3 - Contact The other sheet has many columns, but it has matching columns of the same Column 3 - Region Column 4 - Industry Column 10 - Contact I've tried a bunch of…
©2024. All Rights Reserved Smartsheet Inc.