Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
HELP!!! I am working on a nested IF formula that just doesn't work, any help is appreciated.
I am trying to calculate the total revenue per month as well as the Margin % per month from our Sales Pipeline. Some of the projects run into the following month so we need to see what the revenue and margin are for each part of that time frame.
I was able to get the formula to work for the margin % but only for one cell reference and the start/end dates fall within July. I need to calculate all data within the row and to calculate what % is July and what would be Aug for those projects that run into the next month.
The formula that worked for the single cell reference looks like this =IF(MONTH([Start Date]12) = 7, IF(MONTH([End Date]12) = 7, Percent12))
What I think it should look like is this =IF(MONTH([Start Date]:[Start Date]) = 7, IF(MONTH([End Date]:[End Date]) = 7, Percent:Percent)) However when this is entered I get an error (#Missing or invalid parameters)
Any help is appreciated!