Adding a flag when im under?

Mdelacruz

I want on 1st Colum where says reorder flag, to automatically change to flag if last column "Count yard" is Under. Not sure if that's possible.

Thanks!

Kleerfyre

Put this formula into your flag column:

=IF([Count Status]@row="Under",1,0)

Kleerfyre

Put this formula into your flag column:

=IF([Count Status]@row="Under",1,0)

Mdelacruz

https://community.smartsheet.com/discussion/comment/377568#Comment_377568

Thank you for the help! Will this same formula applied if i had a checkbox instead of flag?

Genevieve P.

Yes! 🙂

Flag, Star, or Checkbox all use 1 to say "selected" or 0 to say "un-selected" in formulas.

Kleerfyre

https://community.smartsheet.com/discussion/comment/377685#Comment_377685

@Mdelacruz yes, what Genevieve said. In any cell that has an indicator like check, flag, or star. If it doesn't and its just a text/number cell, 1 will return True and 0 will return False in the cell.

Mdelacruz

https://community.smartsheet.com/discussion/comment/377685#Comment_377685

Now will it also be possible to automatically change the count status column to under if [visualcount] is less than [stock quantity] or change to over if its bigger? Currently i have a drop down list but i want to be able to plug the number and automatically switch for the user.

Thanks!

Genevieve P.

Yep, you can do this as well! You can use > or < to compare numbers in cells. Here's a Help Article that may be useful: Create and Edit Formulas in Smartsheet

In your case, try something like this:

=IF([visualcount]@row < [Stock Quantity]@row, "Under", IF([visualcount]@row = [Stock Quantity]@row, "Same", "Over"))

I added in one statement to say that if the same number to say "Same" but you can adjust this as needed.

Cheers,

Genevieve