It would be great if there was a way to insert a hyperlink into a cell of a sheet that when clicked would take the user to the row of another sheet. This would be similar to the way one can can click on the Sheet Name for a given row to jump immediately to that row in the given sheet, opening a parent rows to reveal the…
We are wanting to move our documents from SharePoint to Smartsheet. However, one small benefit of SharePoint is that a search done will return results of those keywords if they are in the body of the document, not just the title (excluding PDF's). Is this a function that will be made available in the near future for…
Hi, I have ~30 products each with four price breaks and I need to determine the value for each order (a single product type is listed per row) based on the ordered quantity and its associated price break. The really clunky method I have used so far is two main nested IF formulas and additional columns:- The first main…
Is there a way to create a WebForm that would allow my Project managers to do Weekly updates on each "sheet" or project? If so, Can that information be placed in a central point? It appears I can only create a webform that update to a row in a sheet? Any thoughts, advice or comments would be appreciated. Sincerely, Scott S.
Hi, I have created a production schedule sheet which is viewed by the guys in the workshop. I'm trying to find the best way for them to give me updates on task completion. I dont want to give them editor access to the sheet because this them the ability to change the row details (resource). I have a %complete coulmn which…
Is there a convenient way to assign a fixed reference to a record that remains the same even if new rows are added or deleted anywhere above the record? Something like linking cells from another sheet, only within the same sheet, may work, too. I often want to refer to another record, but if the record number changes as…
Hi I am uding smartsheet to manage the opening of stores in several countries and I invite my internal staff with our franchisee's staff in a a sheet which is a Micro-Planing with 175 tasks to be executed for a neat store opening. Since we are working worldwide, we have several openings happening in the same timeframe. On…
Hi Community, I've got backups under control... BUT what I've found from various options / systems is that the reports can't be backed up. Has anyone found a way to do this?
This has come up a few times (okay, probably quite often!) as to whether there will be a development for the search function to be able to return results for "close match" vs exact spelling. For instance, we were looking for an entry where the last name erroneously had an "s" added to the end. We were looking for the…