-
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…
-
Feature Request - Ability to Email locked fields in the auto-response
We are attempting to use Smartsheet to aggregate some of our quality data. Users score customer interactions and will utilize a web form to populate a Smartsheet. The sheet contains formulas that calculate the actual scores (in a few categories). We need a way to get the results to the evaluator relatively quickly so they…
-
Simple text field option
For a specific row I want to add some notes, more notes than the note column will take, can't use the discusssion option because I want to be able to edit these notes, don't want to attach a googledoc because it just takes too long and I want it integrated in a simple text format. So a small icon to the left that pops open…
-
Attached Documents and Conflicted Copies
On occasion, our functional teams need to edit/add/subtract information from documents attached to specific project lines. The version history information helps us untangle the “conflicted copy” mess we get into sometimes and it seems that Smartsheet isn’t in business to become a document management system. Minimally, it…
-
Need to Receive Out of Office Replies for Update Requests
I created a Smartsheet to collaborate with a department that is in another facility. The nature of our collaboration can be time-sensitive, and when someone is out of the office we need to know. The process that currently exists is to use email, so we get the automatic notification. However, when I tested this with a…
-
linking existing discussion to task
I just got started with Smartview and created a few discussions. Then I wanted to link those to a task. Can't quite figure out how to do that. Later, I found out I could create a discussion from the task line which will then show up in the list of discussions..... Also, what is the order in which discussions are listed?…