RYG Automation- Checkbox and Date

Jess

HI guys,

 

I am quite new to SS and need a tad bit of help

 

I need a formula that will check to see if a checkbox is completed from another sheet as well as it is on today date it will turn the RYG ball green, if the checkbox is checked and not on the right date it will turn Red

 

Please help 

 

 

Shaine Greenwood

Hi Jess,

Smartsheet uses a specific method for creating formulas that reference cells from other sheets. I'd recommend reading through this help center article for more information on how to create a reference to another sheet: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

You'll want to create an IF statement that automates the status of your RYG balls. For example:

=IF(AND({Checkbox} = true, {Date} = TODAY()), "Green", IF(AND({Checkbox} = true, {Date} <> TODAY(), "Red"))

More information on creating formulas in Smartsheet is available here: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet