Pop Up Message

Khari Shiver

Hello,

I don't think this is currently possible, but I'd like to confirm.

Is there an option to configure a popup window to display when a box is checked? I'd like to add a checkbox that removes a row but would like to require the user confirm that is their intent.

Thanks,

Khari

Andrée Starå

@Khari Shiver

You'd add a formula that would show a message if something is true and then combine that with conditional formatting to make it pop.

Would that work?

Andrée Starå

Hi @Khari Shiver

You can't create a pop-up, but you could show a message.

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!

Khari Shiver

Hello Andree,

How would a message be configured?

Andrée Starå

@Khari Shiver

You'd add a formula that would show a message if something is true and then combine that with conditional formatting to make it pop.

Would that work?

Preethy Jana

Hello Andrée Starå,

I am looking for a solution for a similar matter. In my Smartsheet for a tracker, I have a column with three values(High, medium and low) and if someone selects high, the Smartsheet should display a message to show that they need to explain why that particular item is high priority. Can you please elaborate how to do this one?

Thanks,

Preethy

Andrée Starå

Hi @Preethy Jana

I hope you're well and safe!

Try something like this. (you can also add a Conditional Formatting rule to make it "pop" more)

=IF(Values@row = "High", "Please explain why this item is high priority")

Did 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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Preethy Jana

https://community.smartsheet.com/discussion/comment/323499#Comment_323499

It got an error invalid data type. I am not sure if its because of the data type of priority. My priority column is a dropdown with 3 values. Please let me know. I am still learning Smartsheet and this would really be helpful for my project.

Preethy Jana

https://community.smartsheet.com/discussion/comment/323612#Comment_323612

Sorry, I did a mistake in my formula. I used Value function instead of checking for value. Thanks for helping me.

Andrée Starå

@Preethy Jana

Excellent!

Happy to help!

pshull66001

I am trying to accomplish the same but cannot seem to get a formula to work

What I am attempting:

I have one column called "SIT Status" and another that is "Comments".

One of the drop down options for "SIT Status" is "Fail"

If a user sets the "SIT Status" to "Fail" I would like to have a pop up say "Failed items require Comments."

Several failed attempts and this is my recent failed attempt: =IF(SIT Status = "Fail", "Failed items require Comments")

Cannot figure out the formula to make this work

Any help is appreciated

Genevieve P.

Hi @pshull66001

Your most recent formula is correct, however you need to adjust the cell reference.

If "Sit Status" is the column name, you'll need to wrap it in [these], like so:

[Sit Status]

And then we need to add the row reference for that column, which in this case is "the same row as the current formula", or @row

[Sit Status]@row

Try

 =IF([SIT Status]@row = "Fail", "Failed items require Comments")

Another way to do this would be to use a change cell workflow to adjust cell data in your sheet: Change the Value of a Cell in an Automated Workflow

Cheers,

Genevieve

khtmhai5

I am trying to accomplish the same but cannot seem to get a formula to work

Genevieve P.

Hi @khtmhai5

What is it exactly that you are looking to do? Could you spell out the values you have in your sheet and what you want the formula to say for each instance?

pshull66001

@Genevieve P.

Thank you very much for taking the time to help!

Your corrections to my initial formula worked

Thanks Again

Genevieve P.

No problem! I'm glad I could help.

pshull66001

@Genevieve P.

This worked ...but with a caveat

The cells that hold the formula are essentially now locked and data cannot be entered into them.

To circumvent this I could create a column just for the formula and message...but this would be a bit of overkill.

Any suggestions?

A real pop up message would be great. But it doesn't appear to be a current function of SS

Thanks again