Need Formula Help


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


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!