Formula for Different Calculations within one cell
I am attempting to determine spending, depending on the project status. I thought maybe the IF THEN formula would help, but I kept receiving errors when writing the formula.
Project (Column A)
Status (Column B)
Cost (Column C)
Spent (Column D)
Based on the status provided in Column B, I'd like Column D to calculate Column C differently. For Example, if the status is "Planning", then Column D should take the Column C*0. If the status is "Pre-Production"=Column C*0.5, "Production"=Column C*0.7, "Completed"=Column C*1
Answers
-
Can you post the formula that was giving you an error? This will help me understand the logic you need
-
Here's what I tried based on an AI suggestion. However, this always produces the answer 0, no matter what the status is.
=IF([Current_Risk_Status]@row = "Planning", [2024 - Gross]@row * 0, IF([Current_Risk_Status]@row = "Pre-Production (50%)", [2024 - Gross]@row * 0.5))
-
Oh - I think it's working now! I missed a " in the formula in my sheet, but typed it here!!! Sometimes all it takes is to type it out.
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