How to use formulas in DATA TABLE

[Sathish_Kumar_S]

Sample Expected output

Actual Data in Data table

Note: Stored above excel sheet data in DATA TABLE.

Question 1 :

How to add today’s date in this format ( dd.MM.yyyy) in “I” Colum in each row

Question 2:

Fill Total days count in “J” Column for each row

Condition:

Today date – Date of last login (IF date of last login (“H” Column) is empty or contains “ not in use then take date from “E” column)

Question 3:

Fill following value in Column “K” based on the count value in “J” Column

Condition:

=IF(J2<=60,“No Action”,IF(J2>164,“To be deleted”,IF(J2>90,“To be Locked”,IF(J2>60,“To be informed”))))

[Anil_G]

@Sathish_Kumar_S

Even the orther columns can be formulae…

Answer1
For date use "TODAY()" with write cell and then use autofill range or cell activity

Answer2
For the next column again same approach formula would be this

"=IF(H2=""Not in Use"",DATEDIF(E2,I2,""d""), DATEDIF(H2,I2,""d""))"

Answer3
You need to use write cell and auto fill range

"=IF(J2<=60,""No Action"",IF(J2>164,""To be deleted"",IF(J2>90,""To be Locked"",IF(J2>60,""To be informed""))))"

Cheers

[Sathish_Kumar_S]

I would like to write into data table… not into excel sheet…

Which activity we need to use below formula for datatable

“=IF(H2=”“Not in Use”“,DATEDIF(E2,I2,”“d”“), DATEDIF(H2,I2,”“d”“))”

[Anil_G]

@Sathish_Kumar_S

Use a for eqch row in datatable and use if conditions as needed…

Like currentrow("columnname").ToString.Equals("Not In Use”)

This is on example …like this you can write multiple conditions as needed

For date Now.ToString("’MM.dd.yyyy")

Cheers