Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
IF(AND Please help
Comments
-
Can you provide some greater clarification? The main issue I am seeing is that your AND statement should be enclosed in parenthesis..
But I am not sure what your second condition has to be. Status 2 = Won AND what? [Probability hit rate]2=1, then [value of jobs]2, or blank?
Basically your IF Statement should look like this: =IF(And(Column1 = x, Column2 = x), "Provide this result", "Or provide this result".
-
Hi Mike,
E.g. attached..
Thanks
-
What do you want the intended result to be? If Status 4 = WON and the Probability hit rate = 100%... do you want the value of Jobs 4 to be displayed? What do you want to happen if the probability hit rate is less than 1? Do you want that cell to be blank? It looks like you're tallying the amount earned of jobs you've won.
I guess I am confused as to what you are wanting your IF statement to produce.
Try this: =IF(AND(Status4="Won",[Probability Hit Rate]4 = 1), [Value of Jobs]4, "")
Basically, if both of those AND conditions are true, then you will get the [Value of Jobs]4, otherwise, it will be blank. That should allow your tally to calculate up-top.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives