IF + INT/INDEX

Options

Hello! I'm having trouble getting this formula to work (it's giving invalid data type):

=IF(AND({OTD/FTY Range 4}) = YEAR(TODAY()); IF(AND({OTD/FTY Range 1} = "1"; IF({OTD/FTY Range 2} = "90%"; INT({OTD/FTY Range 3})))))

So what I want to do is create multiple if statements. The first is if the year column is the year today; the second is if the month column (it's not a date column) equals the number "x" ("1" being january, etc.); and the third is if the cell value equals to 90%. If all of those statements are true, then I want to index the cell value.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!