Forcing Comment on Status Change

ychang · 05/01/23

We have a column that is formatted with several options in a drop-down menu that indicates the status of a particular line item/card. I would like there to be some sort of pop-up that would force the user to add a comment to the line to when a certain status is selected. Is that possible?

BullandKhmer · 05/01/23

Umm... my first impression is - no, not possible.

As a workaround you could use some sort on conditional formatting to highlight a row where status X has been selected but the comment isn't updated. I'm not sure exactly what this would look like, as a stab you could use the 'last comment column' feature and 2x record date columns one triggered when status X is selected and the other triggered when the latest comment changes and the your conditional formatting rule would be if date A <> date B, then highlight.

I dunno, someone else might have a better idea.

Andrée Starå · 05/01/23

Hi @ychang

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

Have conditional formatting and a formula showing instructions that they need to add a comment and combine it with a workflow that would trigger if they don't fill it in, and it could send an update request for them to add it afterward.

Make sense?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

ychang · 05/01/23

https://community.smartsheet.com/discussion/comment/373867#Comment_373867

I don't know if this is the workaround I'm looking for, but I'm going to try it out and see what it does. This will be an exercise to help me learn Smartsheet a bit more. Thank you!

Andrée Starå · 05/01/23

@ychang

Excellent!

Happy to help!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!

Forcing Comment on Status Change

Answers

Categories