Adding a flag when im under?

Mdelacruz · 05/25/23

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 · 05/25/23

Put this formula into your flag column:

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

Kleerfyre · 05/25/23

Put this formula into your flag column:

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

Mdelacruz · 05/25/23

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. · 05/26/23

Yes! 🙂

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

Kleerfyre · 05/30/23

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 · 05/30/23

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. · 05/31/23

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

Adding a flag when im under?

Best Answer

Answers

Help Article Resources

Categories