Welcome!

RYG Automation- Checkbox and Date

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

Find more posts tagged with

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Need Help Transforming an Excel Checklist into a Smartsheet Form
Hello Smartsheets Community, I need some help in taking the attached Excel Checklist and turning it into a form. The checklist is broken out by category and then by "need" and "want." What is the best way that I can layout this checklist into a Smartsheets form? Any help / ideas would be greatly appreciate it!…
An error has occurred in Smartsheet
I've been having this issue any time I try and access a sheet. I've gone through all of the troubleshooting steps but still incurring the error. I haven't seen much about this in the forums and Smartsheet support is taking a while getting back to me (6 days now), so hoping someone may be able to help me here.
Template Downloads
Hi, I've watched number of training videos, specifically to set up PMO. I followed the instructions to download a template set, but it always adds it to a workspace, not the sheets folder. In fact if i download anything it adds it to a workspace, not sheets folder. What am I doing wrong?