complicated formula
Hello, can you please help me solve this formula.
I don't understand what is wrong with it.
Answers
-
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.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!