Formula with Substitute Value if Blank

1

Hello wonderful people!

Once again I am sure this is quite simple, and I thiiiiiink it might use the IfBlank but I keep getting errors.

My doc is https://coda.io/d/_d-wc9pi434k/Crew-Budget-Breakdowns_suuFsPKv (This is a test doc with no real private info)

My current formula for Daily Cost is:

SumIf(thisRow.[Total Show Days]*thisRow.[Override CPU],thisRow.[Cost Units]=Daily )

I have another Related field pulled in with a “Base Rate”. If the above formula finds that the “Override CPU” field is blank I want it to use the “Base Rate” field amount…but to ONLY use that amount if there isn’t an override rate.

As an aside I have the 2 fields calculating Daily and Project rates then combining them later, and I am pretty sure I could do this in one step?

As always I really appreciate anyone looking at this, my brain just does NOT speak formula!

1 Like
2

Hi Shannon!

I saw your post and thought maybe to give something like this a try:

If(
  thisRow.[Override CPU] == "",
  
  SumIf(
    thisRow.[Total Show Days] * thisRow.[Base Rate], 
    thisRow.[Cost Units] = "Daily"
  ),
  
  SumIf(
    thisRow.[Total Show Days] * thisRow.[Override CPU], 
    thisRow.[Cost Units] = "Daily"
  )
  
)

It might be close otherwise, it checks if the Override CPU is blank, and then the first section will calculate “when it’s blank”. Might need to double check the amounts to see if it gives the result you’re looking for though. Hopefully something along those lines. :slight_smile:

Edit: Not sure about the second part but maybe someone more experienced can help for that!

2 Likes
3

That seemed to have worked great! Now to get the second bit in there, which I suspect will involve the same sort of lines :slight_smile: