Hi - function to remove a flag with a checkbox

Options

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.

Thanks

Claire

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!