Ian✭

Thanks Daniel - is there an ETA on resolving the issue? It is basically making the reminders pointless. Thanks Ian

See attached for the reminder, the sheet, and the notification

use the LOOKUP formula. You can also use index and match together

I am experiencing a similiar issue. I have a report that should only pull in sheet information with the status of "yellow". But over the last couple of days it is randomly pulling in green and blue

I should also note, that I do have reports, but I don't want to send all of the information contained in the row

Remove the % after the 100 and 0

=IF([Account Status]1 = "LOST", [Money Allocated]1 + [Tentative Remaining]1, IF([Account Status]1 = "KEPT", [Money Allocated]1 - [Total Budget]1, 0)) This formula is only looking for LOST or KEPT, if those are not in [Account Status] it will return 0

My reports that have RYG are showing the names "Green, Red, etc" Must have to do with the reporting issues Smartsheet has been experiencing

什么时候新的条件notificat吗ions be released?

I am happy to assist in testing, please email me.