Can I get help on this formula? Not sure where I am getting it wrong.
Stacy Stoffel
✭✭✭✭✭
I need this formula to be one value if Yes and the other Value if not Yes:
Tags:
Answers
-
Does not seem like you need the OR function in there.
=IF([After Hours]@row="Yes", [Total Hours]@row * 375, [Total Hours]@row * 250)
-
I tried that too and got the "unparseable" error.
-
Typo, see your column has a question mark at the end...
=IF([After Hours?]@row = "Yes", [Total Hours]@row * 375, [Total Hours]@row * 250)
-
great thank you! I had tried it so many times, that I missed that question mark. Appreciate the second set of eyes :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!