If cell contains specific text, then return a value

[ricapan]

Hello all,

I need some help.



I have an small excel with 5 rows and I need a formula that inserts a fix date.



The rows are:

Location-task-status-pending-completed



On the status row I have a drop-down menu with 3 options(new,pending,done)



What I exactly need is to convert this formula into a fix date:



=IF(cell="text", value_to_return, "")



So if in “status row” I choose “done option”, in the “completed row” it shows the date this option was chosen.



Where “value to return” is a fix date for the option chose on status and does not change unless you change on the drop-down menu.

I am attaching a screen shoot.



I thanks you in advace for you help.



Best.

 

[Fluff]

We don't close threads. All you need to do is respond saying the solution worked & mark the relevant post as the solution.
Both of which you have already done, so all is good

 

[ricapan]

Thanks to all that assisted,

one last question if I may.

I have this formula also working,
=if(D3="Pending",NOW(),"")

Date	Room	Task	Status	Completed	follow up
			New
			Pending	13/01/2023 14:53:08
			Done

How do I add a second conditions so when is also on status "done" also produce ,NOW() ?
something like
=if(D3="Pending" or "Done",NOW(),"")
Because I try but I am not able to offer 2 conditions on teh formula

thanks in advance

 

[Sufiyan97]

Try

=IF(OR(D3="Pending",D3="Done"),NOW(),"")

 

[ricapan]

I tried and gave me error: Wrong number of arguments to IF. Expected between 2 and 3 arguments, but received 1 arguments.

 

[Sufiyan97]

Sorry not getting what you are trying to say

Can you send screenshot or mini sheet of error you are getting.

 

[ricapan]

 

[Fluff]

Are you doing this in Excel or Google Sheets?

 

[Sufiyan97]

View attachment 82701

I think closing parenthesis is missing in your formula after "done")