Need Formula Help

Automatic Mail

Hi Dear Community ;

I am new about smartsheet so i would like to get your kind supports

i need a formula like that ;

i have a sheet as below with column names , in my scenerio i am getting datas with forms from last users , for example when the last user choosed the "Status" Column as "completed" , i want that the date of completed will be written to "Completed Date " column automaticly.And this completed date will not change again.also if the status has a status without "completed" this cells of the column will be blank.

can you help me to create a dynamic formula in smartsheet pls , i hope it is clerar , thanks in advance for your kind advices

Andrée Starå

@Erhan_79

Happy to help!

Unfortunately, there isn't a specific formula you can use. In my solution, I use a so-called helper sheet and more for it to work.

I'd be happy to share an example. 

Please send me an email at andree@workbold.com, and I'll share it with you.

Andrée Starå

Hi @Erhan_79

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Automatic Mail

dear @Andrée Starå ;

thanks for your kind supports , i searched your post but i could not find the formula that i need properly , i am sorry it is because of me , could you pls share with an example pls.And at the same time i want that my date format will include hour and mınutes format too

Andrée Starå

@Erhan_79

Happy to help!

Unfortunately, there isn't a specific formula you can use. In my solution, I use a so-called helper sheet and more for it to work.

I'd be happy to share an example. 

Please send me an email at andree@workbold.com, and I'll share it with you.

Automatic Mail

dear @Andrée Starå ;

i sent an email to you , thank you veru much for your kind suports and have a nice and safety week !

Andrée Starå

@Erhan_79

Glad we got it working!

Happy New Year!

Automatic Mail

thats a great news @Andrée Starå ! have a nice year too