Hi - function to remove a flag with a checkbox


Hi All

I am sure this will be simple for someone, however I can't find the right solution.

I have a flag column which has the following formula to calculate and is very simple and works perfectly:

=IF([Activity Start Date]@row <= TODAY(), 1, 0)

However I would like this flag then to be cleared if one/or other of two additional columns (which are both checkboxes) are ticked. These columns are called 'Hold' and 'Complete'.

I have tried various solutions - but quite new to SmartSheets and everything always comes back unparseable!

Any solution would be much appreciated.




Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!