teb✭✭

@Andrée Starå I have researched how to do what you suggested, implemented the changes into my Smart, and run a trial to test for effectiveness. It all worked great! Thank you very much.

@Andrée Starå never heard of Alert Workflow with Conditional Steps, but it sounds exactly like what I want! I would need the the multiple Alert Workflows set up to trigger depending on the different options. Thank you. I will start researching how to do this.

@Paul Newcome New problem, same formula. Not all of the answer sets work. I am getting #INVALID OPERATION, but not always. Answer set 1 works, but 2 does not. Answer set 3 does not, but 4 does work. Answer set 5 works fine, but then answer sets 6-25, do not. I cannot figure out why. Any ideas? I am providing part of the…

Yes, I was using Word, in an attempt to make writing simpler since the formula is going to be so long. I appreciate your assistance! I'll give it try.

@Paul Newcome =IF([Current Phase]@row = "Petition Only: Internal Feedback A", "Petition Only: AC-DC Response Letter Reject", IF([Current Phase]@row = "Petition Only: Internal Feedback B", "Petition Only: AC-DC Response Letter Accept", IF([Current Phase]@row = “Petition Only: AC-DC Response Letter Reject ”, “Reject and…

@Paul Newcome The formula initially worked fine, but as I add on to it, I get the UNPARSEABLE error. My answer choices are longer than apple, orange, pear, grape. I am wondering if there is a character limit, if Smartsheet can handle really long formulas? Thank you.

@Paul Newcome Thank you! I got it to work. I thought there was a problem, but I had left out a closing parenthesis. I appreciate your assistance!

Hello @Genevieve P. If my company has that option, I will use it. I reached out to the IT department to find out. Again, I appreciate your assistance. You have been very generous with your time.

@Genevieve P. I used invoices and statements as example; however, that is not what I am doing. It might be best if we could do a Zoom where I could share my screen. I do not have permission from my employer to share anymore data than I already have in a public venue. I do have permission to share on a private Zoom meeting,…

Hi @Genevieve P. =JOIN(COLLECT({Bill Number}, {Unique Value}, "yyy"), ", ") If the unique value is not the row(s) from where I want the data pulled, I don't know what it would be. I thought the unique qualifier was me telling the sheet to use which column number and what row numbers. Aside from being able to use the column…