# complicated formula

Options
edited 06/14/24

I don't understand what is wrong with it.

Tags:

• ✭✭✭✭✭✭
edited 06/14/24
Options

With out any further context into what it is your trying to accomplish I cant really say much as to what's wrong with it. from the outside looking in it looks correct. Based off of the if statement I can make these assumptions.

If Position change is blank, then check to see if end of employment is 1. "Im assuming this is a check box".If so then leave blank.

IF false, Check to see if User Sign is blank. If true leave the cell blank.

If false check Q12 Compleition to see if its blank.

If true then check the cell in employment 2 "not sure why this isn't at @row based on the screen shot",

If Employment 2 is Contractor, Show the cell Start Date 2

If false and employment 2 is Permanent show start date2. otherwise if this errors show a blank.

If Q12 Compleition isnot blank then show q12 compleition

If position change is not blank then show the cell posistion change 2.

Is all this correct?

If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

• ✭✭✭✭✭
Options

Your first arguement, `=IF(ISBLANK([Position Change]@row` needs to have an "IF True" arguement.

```=
IF(ISBLANK([Position Change]@row,"Then Show This",
IF([End of Employement]@row = 1 ,"" , … … …`    `
```

same with the other `isblank `function. What do you want to happen / show if that cell ISBLANK?

...

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!