How do I separate numerical and text values of differing lengths from a single cell into separate columns? For example, I'm trying to total the "AREA" Column, but due to having "SF" in the cell, it wi…
Hi Everyone, We have a form which will be filled by the customers. There is a attachment field added to the form. Now, we want two types of attachments to be done - 1. Invoice copy & 2. Images of the …
Hi, Is there a way to allow users to email comments without viewing the smartsheet? Is it possible to modify the email that gets sent when you @someone@something.com from the automation@app.smartsheet…
Hi, I am currently trying to create an Index Match function which will be able to search multiple sheets (5 to 6 separate sheets) for the correct information. The destination sheet has two columns tha…
Hi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can ge…
Our sheet is used as a chronological order of events. Often when others are working in the same sheet, everything gets set out of order. I know Smartsheets does not support autosorting outside of repo…
I have another complex situation Now that I figured out how to "batch" items. The next thing I need to do is pull in a list of "Tote Numbers" that are associated with that batch. In this case I DO wan…
I have 8 conditions I need to string together, if all are met the formula should return "yes" if anything any condition is false, the formula should return "". I have tried nesting If/ and statements …
Is there a way to make a recurring event for weekly or monthly easily? I know that I can copy and past into the grid and change the dates but I'd rather use a recurring function. For example, a Saturd…
