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…
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…
在SmSh,它是伟大的我们可以用符号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? ✓✫↔↗♂♛金☺✔✖☑☌✉∅♪♫
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
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…
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…
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…