Change Notification
답변함Does anyone know if there is anyway to flag a cell if it's value is not zero? we have a checks file and although our team does a good job monitoring the spreadsheet to make sure our differences are zero, we do run the risk of missing one because we have several check files. So is there anyway to turn on notifications when those check cells change to anything that is not zero?
-
공식 댓글
Hi Jennifer! Great question, I would recommend using conditional formatting for this. You will just need to create a rule to detect non-zero values in the relevant cells. Take a look at our support page on conditional formatting here: https://support.workiva.com/hc/en-us/articles/360035643032-Conditional-formatting-in-spreadsheets
Thank you Brandon.....we already use conditional formatting which definitely helps. I was wondering about notifications only because at one point we have like 6 audits going on with 6 different check files, we also have a quarterly and annual bond disclosure going on around the same time. Although we do try to keep an eye on the check files, we had an instance last year where one was almost missed. Thank you for the suggestion....it definitely makes it easier to spot issues.
0
Hi Jennifer! Sorry for the delay. I don't believe that this is a current feature of the platform. I have submitted a ticket to our product team to see if this is something we will be able to implement. You will be notified of any updates regarding this. Let us know if you have any additional questions. Have a nice day!
0댓글을 남기려면 로그인하세요.
댓글
댓글 3개