If/Then with popup

sholmes

Hello, I am trying to use a response in one cell to trigger a message in another but then I also need the cell with the trigger to allow me to change in the info without going back to the original column to take off what is trigger as I need that info as well.

Andrée Starå

Hi @sholmes

I hope you're well and safe!

Not sure I follow!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to 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!

sholmes

Hi, I am doing well hope you are. I have not created it yet, I am not sure how but I have a sample below:

jmyzk_cloudsmart_jp

Hi @sholmes

By Form Logic

A standard way to do this is to use form logic.

Please check with the form below by inputting yes or no.

https://app.smartsheet.com/b/form/1cb0d3c8d2cc456ba8649cb47d6405fc

By IF Statement

If you need to edit the sheet, use the IF statement to show the Message if Column B is yes.

Example:

[Message to show when Yes] column

=IF([Need Update?]@row = "Yes", "Message", "")
=IF([Need Update?]@row = "Yes", "Enter Date to the right 'Date update is required' without updating yes in the 'Need Update?' column", "")

The published demo sheet is editable, so you can check how the formula works by adding yes or no value to the [Need Update] column.

https://app.smartsheet.com/b/publish?EQBCT=a1ee543cf41746a993dbf07123f299d7

sholmes

I guess my question is, if I have logic on the cell to put a message there if one cell has yes, but then I update the message to a date once the updates are done. will the logic keep trying to put the message there since the driving cell will keep the yes which is the logic/trigger?