Can we do multiple IF statements? I've tried to use IF and also OR to complete the function I'm trying to do and nothing seems to work. I want my Status column, "Not Started", "In Progress", and "Completed" to be based off of the % indicated in the % Completed column so I don't have to remember to change the status when the % completed changes. I know I've done this before in Excel but not sure Smartsheet can handle an IF statement with multiple conditions. Here is the logic... IF % Completed = 0%, then return "Not Started" IF % Completed = 100%, then return "Completed" IF % Completed is between 1 - 99, then return "In Progress" OR this could also be IF the first two logics are FALSE then return "In Progress". Thank you, Kim

You chain together additional conditions within the IF function. =IF([% Complete]2 = 0, "Not Started", IF([% Complete]2 = 1, "Complete", "In Progress")) In this case, I have placed a second IF function in the False result of the first IF function. NOTE: you can put IF's or other functions in an IF functions TRUE or FALSE returns.

Multiple IF Statements

Options

Answers

Mike Wilday Community Champion

04/01/24

Yep... just saw the same thing! :D Thanks... I wish I would have just looked at the whole thread first. hahaha

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Asset Management - Due in 7 Days not working
This is part of the asset management template. The stock formula has a category for assets due in 7 days. I wanted to change that to within 7 days, and I looked up this formula that is supposed to do the trick: =COUNTIF({Sheet - Asset Management Sheet Range 2}, TODAY(7)) However, it is still only returning assets due in…
Formula VLOOKUP or maybe an alternative solution
Hello, I am trying to develop a formula that will reference another sheet and bring back the content from a specific cell. Need to reference two columns for the match in the reference sheet. The match component will come from a column [PI or Account #] on the main sheet to be searched in column 1 on reference sheet and…
Concatenate Formula in SmartSheet
I am in the process of migrating workbooks from Excel to SmartSheet, but am having trouble with the Concatenate formula. I have a column of store numbers and am trying to automatically create the store manager email to be used across different sheets, but I cannot use the concatenate formula in SmartSheet the same way as…

Multiple IF Statements

Answers

Help Article Resources

Categories