IF formulas
Hi,
Tried looking for my question hoping it was already answered, loving how Smartsheet community works.
I'm new to Smartsheet and need help with an IF formula.
My company has several titles (positions). In the Title column there is a drop down menu for 5 Titles. In another column, I have their Rounded Hours for per line.
I have created three separate columns that will eventually subtotal hours per Title.
So, if Title $1, enter the Rounded Hours for that line. if Title $2, enter the Rounded Hours for that line (we are temporarily combining Title $1 and Title $2). If Title $3 $4 or $5, enter 0 for that line.
This is what I tried.
=IF(Title8=Title$1,[Hours-Rounded]8, IF(Title8=Title$2,[Hours-Rounded]8, IF(Title8=Title$3,"0", IF(Title8=Title$4,"0" IF(Title8=Title$5,"0")))))
Thanks so much!
Danielle
Comments
-
Hi Danielle,
Try removing the quotes around your numbers. Only text strings should have quotes around them in Smartsheet formulas.
There's also a missing comma between your second-to-last and last IF statements:
=IF(Title8=Title$1,[Hours-Rounded]8, IF(Title8=Title$2,[Hours-Rounded]8, IF(Title8=Title$3,0, IF(Title8=Title$4,0, IF(Title8=Title$5,0)))))
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives