NateP✭

Still waiting on a resolution to this. Update request look very generic without the logo and coming from a "Name via Smartsheet." I have to do a lot of manual emails now because customers who don't know my name specifically often ignore spammy looking emails.

I'm having the same issue. Update requests do not have our logo, but normal notifications do. Customers are either contacting us asking if the update request is legit or not using it at all and possibly worse, flagging it as spam or unsubscribing. It's even worse that the email header says my name via smartsheet which many…

Thanks James and Kelly. Before I got James' suggestion, I had basically done what he had suggested. I created a couple helper columns in the reference sheet, one which stripped BASE out of the id and one which identified if that row had BASE included. The formula I used to strip the word BASE out was =IF(BASE@row = 1,…

Not quite. What I'm looking for is to see if the SKU in the main sheet, is referenced in the the reference sheet with the suffix BASE and if so, add that suffix in the id column of main sheet. Here's some more examples. You can see that not all SKUs can find a reference with the BASE suffix so they don't get the suffix in…

In case its not clear, i don't want to use the checkbox anymore

Summer, I want the Override bend time checkbox to be completely manual. I will check that box when I see something out of whack. So here's how I'm using this information. I have a SKU that I'm collecting various manufacturing times in the process. Sometimes that data is not available yet....my workers have not worked on…

I played around with it and got it to work. Just added in the italicized section in front of my original formula. =IF([Override bend time]@row = 1, [Estimated Bend Part time]@row, IF(AVERAGEIF({Part # reference 1}, SKU@row, {Bending reference 1}) <> 0, AVERAGEIF({Part # reference 1}, SKU@row, {Bending reference 1}),…

For posterity, here is the formula I ended up using and it works beautifully. Now I'm going to go through and fill out my estimated times but once real-time data in my other sheet is added, it'll override my estimate. =IF(AVERAGEIF({Part # reference 1}, SKU@row, {Machine time/part}) <> 0, AVERAGEIF({Part # reference 1},…

Thanks for the help ladies. I think that the filter feature in smartsheet is good but I definitely would like to see some enhancements so its a little more in depth like the automations. @Kelly Moore This seems like a good idea as it will override the manual data once real-time data is populated. I have quite a few columns…

That worked...I just had to add an A to VERAGEIF in your example above. Thank you so much. That just helped so much. All those years of collecting data with no real purpose helped fill in all the gaps with this formula.