If Formula
=IF([Work Performed Total]@row / [Employee Count]@row * 12 = 0, [Revenue Projection]@row / [Employee Count]@row * 12)
Why is it if the work performed cell is greater than 0 then the answer is blank? I want it to use revenue projection as the normal answer until work performed numbers start getting entered
Best Answer
-
It sounds like if the “Work Performed Total” is 0, you want the formula to calculate [Revenue Projection]@row / [Employee Count]@row * 12, and if the “Work Performed Total” is greater than 0, you want the formula to calculate [Work Performed Total]@row / [Employee Count]@row * 12.
If that’s correct, try this:
- =IF([Work Performed Total]@row = 0, [Revenue Projection]@row / [Employee Count]@row * 12, IF([Work Performed Total]@row > 0, [Work Performed Total]@row / [Employee Count]@row * 12))
Does that work for you?
Georgie
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
- =IF([Work Performed Total]@row = 0, [Revenue Projection]@row / [Employee Count]@row * 12, IF([Work Performed Total]@row > 0, [Work Performed Total]@row / [Employee Count]@row * 12))
Answers
-
Good morning!
It looks like your If statement is looking for a value of 0
[Work Performed Total]@row / [Employee Count]@row * 12 = 0
and if that's true it will return the calculation
[Revenue Projection]@row / [Employee Count]@row * 12
Perhaps you intended your condition statement to read >0?
-
the proper structure of the if function is:
if (logical_expression, value_if_true, value_if_false)
I can see you formula you have only one comma so it means that if the condition is false it will be blank.
Hope this helps.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
Yes, I need it to read if true. Can you help me write it? Basically if the worked performed is 0 then I need it to calculate the other formula. But if its greater than 0 then it need to calculate the first formula
-
It sounds like if the “Work Performed Total” is 0, you want the formula to calculate [Revenue Projection]@row / [Employee Count]@row * 12, and if the “Work Performed Total” is greater than 0, you want the formula to calculate [Work Performed Total]@row / [Employee Count]@row * 12.
If that’s correct, try this:
- =IF([Work Performed Total]@row = 0, [Revenue Projection]@row / [Employee Count]@row * 12, IF([Work Performed Total]@row > 0, [Work Performed Total]@row / [Employee Count]@row * 12))
Does that work for you?
Georgie
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
- =IF([Work Performed Total]@row = 0, [Revenue Projection]@row / [Employee Count]@row * 12, IF([Work Performed Total]@row > 0, [Work Performed Total]@row / [Employee Count]@row * 12))
-
=IF([Work Performed Total]@row=0,[Work Performed Total]@row / [Employee Count]@row * 12, [Revenue Projection]@row / [Employee Count]@row * 12)
I think this is what you are looking for. Like @kowal said, you were missing an IF false statement.
Let me know if it works.
Itai Perez
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
hi @Samuel Dowdy Jr. sorry for late response but as I was not tagged I did not get the notification.
Is your problem already solved?
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
@Georgie answered my question. Thank you so much everyone.
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
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!