Can a comment be "transposed" to a cell?

Hello,

I am looking to have a comment "transposed" to a cell. We use a form for access requests. Currently, the approver can comment when approving or declining. Our stakeholders would like to automate the decline message to go to the end user. But I am not able to add the comments to the "alert someone" automation when declining. So we created a column called "Reason for Declining", but I am unable to figure out how to have the data in the comment section moved to the "Reason for Declining" column. Is there a way to do that? Or a way to have the approver fill out the cell in the form?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!