Skip to main content
Question

check box when last modified by a certain user

  • January 20, 2018
  • 0 replies
  • 117 views

I want a check box formula to be checked if the following is correct:


1- last modified by a certain user

AND

2- another numeric field is > than a certain  value

This topic has been closed for replies.

Hi Eyad,

If(UserToName([Last Modified By])="Your User Name" and [Your Numeric Fiedl]>(Your certain value), true, false)

Thanks,

Gaurav Sharma

  • Author
  • Registered
  • January 20, 2018
Thank you very much Sharma, but I don't know why it did not trigger the box. should I put the user name as it shows on QB : (Surname, First name) ?