クラシックファイルタイプは、2021年1月をもって使用不可となりました。クラシックファイルを移行するか、PDFをダウンロードすることができます。 詳細を見る

Importing Excel Workbook with formula @SUMIF - not working

0

コメント

5件のコメント

  • Isabel Messore

    Welcome to the Community Jonathan Santamaria!

    The thing to check out is if all of column M and column E are formatted as Dates and not Text.  My gut say they are not, because one is left aligned the other is right aligned. Let me know if this helps!
    0
  • Jonathan Santamaria

    Thank you Isabel Messore.

    Yes, verified all formats are in-line and consistent.  Formats in use are "dates" for dates and "accounting" for the numbers and "text" for the labels.  Still no results on the SUMIF formulas.

    As to the alignment, one thing we are noticing when we import, the alignment that comes in to Workiva workbook are not consistent with what's or how displayed in Excel.  Some numbers and dates in Workiva go in to left alignment while in Excel all these cells are in right alignment.

    Hopefully, you have more insight on troubleshooting the SUMIF formula issue.

    Also, goes out to the Community for any help on the formula and alignment issues.  Thanks.

    0
  • Isabel Messore

    Hmmm very interesting Jonathan Santamaria,

    My initial thought was that it was a circular error, but that doesn't seem to be the case either. You could try clearing that cell and typing in the formula again, instead of relying on the import result. If that doesn't work, I've connect you with Support. They will be able to provide a more in depth analysis of the issue you're facing. Hang tight!

    0
  • Maria Ortega

    Hi! I have the same problem, the SUMIF formula doesn't work, there is any new insights about this?

    0
  • Tyler Ferdinand

    Hi Maria,

    Unfortunately, there are no new insights on this subject matter.

    Please reach out to Support if the SUMIF formula continues to cause you problems.

    Have a good rest of your day!

     

    0

サインインしてコメントを残してください。