-
Task completion updates
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…
-
Absolute record references
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…
-
How to merge the tasks from multiple sheets for a single user ?
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…
-
Preserve leading 0's:
-
Backup Reports & Templates
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?
-
Search Results - intuitive vs exact match?
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…
-
Convert Text to Number?
Is there a way in a Smartsheet column to convert a Text value into a Numeric value? For example, I have a column called "Duration", formatted as a "Text/Number" column type, and I have values in that column that are in the HH:MM:SS format, and look something like this: 00:15:00, 01:20:00, etc. I'm trying to add a few of…
-
✓ ✖ ➜ easily inserting symbols?
In SmSh, it is great we can use symbols in the text cells, and also in formulas like =IF(FIGURE7 < 20, "☺", "♛") But could we get an "Ω" button to make it quicker than copy-paste from google docs? ✓✫↔↗♂♛金☺✔✖☑☌✉∅♪♫
-
Time Logger - Cell History
Is it possible to show time spent on a particular project? The data is already there within the cell history - it just need to be extracted somehow. The below data tells me the task has been "in progress" for 1 minute - 21.06 - 21.07
-
Feature Request: Rank order macro
We recently migrated from a google doc to smartsheet for tracking a project portfolio. Google docs offered the ability to apply a Rank Order macro to let us sort the list based on a calcuated priority score for each project in the list. Here is an example of the macro: =rank(AQ3,AQ:AQ) Smartsheets lets us score projects…
