Comments
-
The column we want the sum to appear in is "Jan 23 Spent to Date". Maybe if I explain it like this. If the "Budget Type" is "Estimate" AND the "Month" is "January" AND "Director approval" is either "Approved or Submitted" add the "Requested Amount" to "Jan 23 Spent to Date". I have a workflow set up where when our…
-
@Frank S. - I have another question for you. The formula that you provided works great by the way! Can you help me with a formula for "Jan 23 Spent to Date" column that reads to the following logic? If "Budget Type" is "Estimate" and the "Month" is "January" sum the "Requested Amount" column BUT if the "Budget Type" is…
-
@Frank S. Thank you this is exactly what I was looking for!
-
@sharkasits it worked when i updated the references. thank you!
-
@sharkasits that worked, thank you! I am also getting an error on this formula. =SUMIFS({Square Footage}, {Start Date}, >=[Start Date]@row, {Start Date}, <=[End Date]@row, {Status}, OR(HAS(@cell, "Complete"), HAS(@cell, "Construction"), HAS(@cell, "Executed LOI"), HAS(@cell, "Priority")))
-
End Date =DATE(VALUE(RIGHT(Quarter@row, 4)), VALUE(MID(Quarter@row, 2, 1)) * 3 + 1, 1) - 1
-
I entered as a column formula and I received a few invalid values.
-
It works. Thank you!
