complicated formula

edited 06/14/24 in Formulas and Functions

Hello, can you please help me solve this formula.

I don't understand what is wrong with it.



  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 06/14/24


    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.

  • heyjay
    heyjay ✭✭✭✭✭

    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!