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!
Suzanne Eger
