Is there a way to workflow opening another sheet if a box is checked on the master sheet?

Chris Kidd

Lets say I want a workflow that is when column QC Failure is checked it opens sheet QC Details that then can be filled in?

Is this possible within SmartSheet to do?

Andrée Starå

Hi Chris,

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a workaround, you could display a message/instruction or similar.

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!

Andrée Starå

Hi Chris,

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a workaround, you could display a message/instruction or similar.

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!

Chris Kidd

I will put in the Enhancement Request, but

in the workaround how would I display a message/instructions?

Chris Kidd

If I have a cell that needs input, like a persons name, but if that info is not filled out based on another column how would I make it generate or display a message?

I have column - Plates Made By, I want a message to display if this info is missing.

Based on column, # of Plate Made, Shift, Plate Size (Inches) so that if data is in these columns it displays that info is missing from Plates Made By

Does that make sense?

Andrée Starå

@Chris Kidd

Did you get this working?

It would look something like.

=IF([Plates Made By]@row = "", "Message Text")

Chris Kidd

@Andrée Starå

What I did, and it's working, but if there is a better way, I am all for using that, is the following...

=IF(OR(ISBLANK([Plates Made By]@row), ISBLANK([Plate Size (Inches)]@row), ISBLANK([# of Plates Made]@row)), "Please Fill in any missing Plate Making Information before continuing.")

Andrée Starå

@Chris Kidd

Excellent!

Glad you got it working!

One change you could make would be to exchange the ISBLANK to ="", but after the @row part.