Hi there! Still learning how to make full use of formulas and write more useful IF() statements.
In this case, I’d like to flag tasks that should have been started but haven’t been or that haven’t been marked finished after their deadline is either today or has already passed as “Delayed” (and otherwise are “On Schedule”)
Of note is that my Status field is a single-select field, so not sure if that “=” is what’s throwing this off or if it’s just fundamentally way off-base. Any help is appreciated!
When you’re nesting a bunch of functions within one another, it can be really easy to lose track of the syntax if you aren’t used to keeping your structure tight.
When working through deeply nested formulas, I always like to either:
Write out, in plain language, the ‘story’ of what I’m trying to build. In some scenarios, I like to diagram it to keep track of what’s happening in my formula. The same thing is applicable when writing code.
Build the formula in modules. When thinking about the ‘story’, break it up into chapters and write it independently. Once you have all the parts of your modules, you can piece them together.
Just some things that help me when working through more complex formulas.
Hi Ben! Thanks a lot for your response! I actually want to limit only to the 2 returns (“Delayed” and “On Schedule”) because of the way I’d like to reference this field in another table. Your response has been really illuminating in how I sort of screwed up the syntax on the AND() and OR() commands. I think what I was doing was writing them sort of grammatically (IF this is true, AND this is true) instead of as a command on 2 statements.
I’ve reconfigured my formula below, but this still doesn’t read. Do you have any feedback on where I’m going wrong here?
EDIT: I tried the formula again but as a nested IF() statement like you demonstrated, but still won’t read. I keep going through the syntax and it makes sense to me, so I’m unsure where I’m going off-roads here?