Why are my formulas suddenly not working?

Amy Tyner
Amy Tyner ✭✭✭
in Formulas and Functions

Hi,

I have created formulas in the past and have even used your AI helper option to create formulas with good results. Yet, over the past couple of days whether I use AI or create a formula I am getting either an unparseable error or some other error. Please help. I am simply trying to count the number of in progress items that are listed as a Risk" on a sheet. Thanks!

· Share on FacebookShare on Twitter

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭

    @Amy Tyner? Could you provide the current formula you are trying to use?

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter
  • Amy Tyner
    Amy Tyner ✭✭✭

    Hi!

    Here you go. Please note in this case I am asking for the formula to check the RAID column and count if that RAID is a Risk with an Open status. I tried adding in the AND after the "Risk", but that didn't change my unparseable result. I also tried changing from COUNTIFS to just COUNTIF, same result.

    =COUNTIFS([RAID Category]:[RAID Category], "Risk", [Status]:[Status], "Open")

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!