Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
IF Statement to populate cell based on Check Box & Text in same row cells
Hello Smartsheet Community Members!
Is it possible to write an IF statement to populate text from one cell in the row into another cell in the row ONLY IF a particular box is check in the same row?
To put this into context, I would like to display key text onto a project Sight on a regular basis without the PM having to manully update the sight either by repointing a metric widget to a new cell each week or by manually entering Rich Text -
In particular, I am creating Issues/Risk/Management Asks Log sheet to maintain a running log of these items and would like to highlight on the project Sight any current issues, risks and management asks - WITHOUT having to repoint my metric widget each time or update a Rich Text. My desired approach (unless there is a better way to do this) is to set up my sheet with a column for Issue/Risk, a column for Management Ask, a check-box column (indicating to include on the Sight if the box is checked) and two columns on my sheet that will auto-populate with the issue/risk text or management ask text from, but only if the cell with the check-box is checked. I also have a Date Identified column as well (amongst some additional columns).
I am not sure how to write the IF statement to account for YES, Box is Checked AND include the text from Column "Management Ask" (or the Issues/Risk column, respectively - these will be two distinct formulas).
Any help is greatly appreciated!