Greg_Gillet1 - profile

Greg_Gillet1 · Feb 12, 2020

I’ve tried copying and adapting examples from this forum (many thanks all to those who contribute!) and I’ve tried writing formulas from scratch… nothing seems to work! I’m using a very simple base to record my daily step count. I have a field calle...

Greg_Gillet1 · Feb 12, 2020

Nathalie - thank you SO much! Copying your formula from the forum still didn’t work, but copying your base and THEN copying the formula out of the field into mine DID work. I wonder if it was something to do with having some (not so) smart quotation...

Greg_Gillet1 · Feb 12, 2020

Nathalie_Collins: IF(Steps>19999,“Yay”,IF(Steps>9999,“OK”,“No Comment”)) Thanks, Nathalie. Looks like it should work, but I’m still getting: “Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.”

User Statistics

User Activity

What am I doing wrong with this simple nested IF?

Re: What am I doing wrong with this simple nested IF?

Re: What am I doing wrong with this simple nested IF?