I have a column "Status" and when "Completed" is chosen from the dropdown, I'd like a calculated column to show the date of that day. Is that possible with an 'If And" statement?

1 Answer 1


Create a new column named Today and then create calculated column as below: =IF([Status]="Completed",[Today],"")

Delete the Today column created earlier and it will work as expected i.e. whenever Status is Completed,Calculated column will show Today's date enter image description here


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.