Best Of

Re: Pull data from a sheet to another with multiple columns

Assuming the other columns are truly blank, you could add a helper column to join them together and then INDEX/MATCH (more efficient) or VLOOKUP to pull the data from that column using your primary column as your reference value. The blanks would just be nothing added to the helper column, leaving you with the customer lot # from the one column with a value in it.

Your formula for your helper column would be as follows:

=JOIN([Customer Lot # HTOL]@row, [Customer Lot # PTC]@row, [Customer Lot # bHAST]@row, [Customer Lot # ELFR]@row, [Customer Lot # ORM]@row)

INDEX/MATCH formula would be as follows:

=INDEX({Helper column},MATCH([Product Name]@row,{Product Name column}))

AdamSYNH

1 ·

Re: Activity Log should reflect all changes made to a sheet (in detail) including Workflows

Please vote in the idea for this activity log of notifications so Smartsheet considers as a feature in future releases: https://community.smartsheet.com/discussion/138996/audit-trail-all-emails-that-are-sent-out-using-automations/p1?new=1

fcooke

1 ·

Re: Making a new sheet after the most recent update

You are helpful. The change, not so much. Thank you anyway.

Bill Raymond

1 ·

Re: using NOT

sss @michellelkirkland A couple issues with the formula that jump out.

You have the Tracker Range 3 right after the Tracker Range 2, that is not the correct syntax. You need to use the criterion for each range right after the range.

Also for the not function you would just say:

not(@cell = "closed")

Darren Mullen

1 ·

Re: OFFSET() function

I did a quick search to see if there was another feature request for the offset function, and I was surprised to find that there wasn't.

I think this is a great idea!

SSFeatures

2 ·

Re: New Membership versus License Model

Another fail by Smartsheet. I work for a small non-profit and our budget is tight. I just realized that this change tripled my licensed user number. This is underhanded and dirty. To remove these licenses it now requires 30-day notice and you can only do it at this website: https://help.smartsheet.com/contact/downgrade

Horrible customer service and while the product is a good product, between this and the inability to save in the Sheets folder, it seems to be moving toward an unusable product. Now I will have to monitor the tune-up member list on a weekly basis or get caught spending more money than budgeted. So basically now everyone without a licenses has to be a viewer unlike before they could be an editor. Ridiculous and disappointing.

PLD

1 ·

Re: New Membership versus License Model

@Barry Bowles which alternatives have you looked at? Has anyone reach out to Blackstone and Vista Equity partners directly to let them know the risk of losing multiple customers loyalty, this also is a risk of Smartsheet's reputation. If you have or know someone who reached out to them, did you get a reply?

Matt Kirby

3 ·

Re: New Membership versus License Model

I'm very disappointed about this pending change. I chose Smartsheet as our portfolio management software because anyone in our organization could collaborate without needing a license. If this is the future of Smartsheet, we will reconsider other options.

Scott Carper

2 ·

Bolding Text in Automation

I would love to be able to create bolded text in automated messages. Currently there doesn't seem to be the ability to do so.

LFeliciano

4 ·

Re: Email Error

Hi @mimi_McCPetco8, does it always complain about the same row ID, or does the number change? I'm wondering if it's only one email that's causing the problem, or if there are multiple emails that Smartsheet doesn't like.

If you have a lot of rows, it can be difficult to manually go through each one to check the row ID.

If you're comfortable running code in your browser's Developer Tools console, you can paste in this code and it will tell you which row corresponds to '4112981658832772', so that you don't have to manually go through each one by hand.

rowId = 4112981658832772


grid = formObjectHandler.getFormObjectByConstructor(JscMegaGrid)

rowNumber = grid.gridRowSet.findIndex((row) => row.pvt_gridRowMaskedID === rowId)


console.log(`The rowNumber is ${rowNumber}`)

Hope this helps!

SSFeatures

1 ·