Help with RYG IF Statement and consider a Blank Cell

Richard Heath

I have a sheet to measure KPI's for a project. Bascially I'm trying to record when we submit a report;

• If the Submission Date falls before the 4 Week Limit (Purple Helper Column) KPI 2 returns Green
• If the Submission Date lands after the 4 week limit but less than 14 days 'late' KPI 2 returns Yellow
• If the Submissinon Date lands any later, KPI 2 returns Red.

So far so good and the below demonstrates this.

My problems is that the Submission Date remains Blank until we issue a Report. I'm trying to prevent KPI 2 from defaulting to the Green ball and instead returning a blank field when Submission Date is blank.

The formula I'm using is per the following, which is based on IF Statements working backwards (based on @Paul Newcome advice on https://community.smartsheet.com/discussion/comment/249788#Comment_249788)

I've tried to include a IF Statement with <>,"" at the start of the equation and also at the end, but it isn't working. I'd always tried IFERROR, but no luck. I'm almost there, but some help would be appreciated.

Any solution to force a blank result would be appreciated.

Regards,

Richard.

Paul Newcome

Try something like this...

=IF([Submission Date]@row <> "", original IF statement)

Just don't forget the extra closing parenthesis on the end, and you should be good to go.

Paul Newcome

Try something like this...

=IF([Submission Date]@row <> "", original IF statement)

Just don't forget the extra closing parenthesis on the end, and you should be good to go.

Richard Heath

Thanks again for all your help. Worked perferctly.

Paul Newcome

Happy to help! 👍️