Use of formula in columns for CWM board

mnawathe
Tera Contributor
Hi,
 
I am trying to see if there is a way to use formulas in CWM columns as we do in an Excel spreadsheet. Basically, what I want to do this:
 
Let's say there are 2 columns as shown below - A & B. The column type is Number. I want to add the value in columns A and B and put it in column C.
 
mnawathe_0-1746215665236.png

 

These are all custom columns created for this board. The automations do not allow me to select any custom columns, and I don't think it lets me use any formula, so I don't know what else I can use.
 
Please note that I am not using any other applications or features like Project Management, etc. I only want to use CWM and want to see if any kind of calculation can be done with the CWM board columns.
1 ACCEPTED SOLUTION

Sunil B N
ServiceNow Employee
ServiceNow Employee

Hi Mrunal,

 

Unfortunately this capability is not available currently in CWM. 

However if these fields are applicable across your organisation, you can add to CWM task table and add a business rule to do the calculation.


Please note that we will track of this use case for future roadmap of CWM. 
Thanks and regards,

Sunil B N

View solution in original post

2 REPLIES 2

Sunil B N
ServiceNow Employee
ServiceNow Employee

Hi Mrunal,

 

Unfortunately this capability is not available currently in CWM. 

However if these fields are applicable across your organisation, you can add to CWM task table and add a business rule to do the calculation.


Please note that we will track of this use case for future roadmap of CWM. 
Thanks and regards,

Sunil B N

Thank you.