IF Function / Formula Help
I have created a budget sheet template and need to add seasonlisation to identify cross-charges by month. Rather than doing this manually every time, I would like to add a formula that pulls the data from another cell, but based on information in a 3rd cell. I was hoping it would be as simplistic as: =IF([Activity Month]3) = Sep, [Revised Budget]3); however, I am getting an UNPARSEABLE response.
This image show's the 2 cells that have the information in (3rd cell where the formula will be is off to the right). Is this even doable, and if so, any help with the formula would be greatly received.
Thanks
Ken
Best Answer
-
Your syntax is just a bit off is all.
=IF([Activity Month]3 = "Sep", [Revised Budget]3)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Your syntax is just a bit off is all.
=IF([Activity Month]3 = "Sep", [Revised Budget]3)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Ken Alder Hi, your formula as is missing the no part: IF(logical_expression,[value_if_true],[value_if_false]) If it's not September then the cell can be blank so it'll be like this =IF([Activity Month]3) = Sep, [Revised Budget]3, " ")
-
@Razetto The "no" part is not necessary. The issues causing the error are the closing parenthesis after the first cell reference and the lack of quotes around the text string.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!