Need an If/Then formula for this
IF "Staff or Freelance" column is "Freelance" then I want to multiply In Rate * Planned Hours and have the result show in the "Freelance Cost" column. if it's "Staff" there should 0 value in the "Freelance Cost"
Thanks
Best Answer
-
Hey @JPFisher,
Have you tried an IF formula in the Freelance cost column?
It will be like this: =IF([Staff or Freelance]@row = "Staff", 0, [In Rate]@row * [Planned Hours]@row)
I hope I understood correctly.
Let me know if it works for you!
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
Answers
-
Hey @JPFisher,
Have you tried an IF formula in the Freelance cost column?
It will be like this: =IF([Staff or Freelance]@row = "Staff", 0, [In Rate]@row * [Planned Hours]@row)
I hope I understood correctly.
Let me know if it works for you!
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
Thanks - I just couldn't get it and that did the trick!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!