-
Capturing Email Responses
I would love and really need to capability to for Smartsheet to capture responses to emails in the comments. Example if a user sends a document for comments through SmartSheet email as users reply back I would want to see those replies in the comments. Rather than having to log into smart sheet leave a comment and then…
-
Including only the most recent comment.
Hi there, Within the "Print Setup" for .pdf reports, under "Options", "Include comments" checkbox....when selecting this checkbox it prints out the full set of comments which is fantastic but can make the report quite lengthy, especially over time. However is there a way, or is it possible in future upgrades to select an…
-
Gantt Chart - Show Repeat activity every fortnight / month etc
Hi All I am wanting to show an activity that needs to happen every week or month on a Gantt chart in one row. Any suggestions please?
-
Annual School Operations Calendar
Can anyone recommend a format for an annual calendar for our school operations team? What I'm trying to create is a document to input all school activities for the year and plotting each department's tasks for each job. For example: School Open Day: events showing each department's tasks to achieve effective outcome. So…
-
Work around to formulas across sheets
I am working with 2x sheets - one a CRM, the other a job list. I would like to be able to flag on the Job list when a customer name is entered which is not already in the CRM. In Excel I could use a combination of ISERROR & MATCH to achieve this, however from what I can work out formulas across sheets is not possible on…
-
Project with Multiple Dates and Hours
I'm working on a project that I completed over two days and want to document my hours for both days. Sometimes we work on projects over several days in different weeks. How can I enter all this data. Right now I only have one column for Date and Hours. Am I able to add more columns to enter more Dates and Hours?
-
Currency converter
Hi, I have project expenses in different currencies (EUR, GBP, CHF, AUD) and need to convert them all in USD. Is there a solution how I could enter fix exchange rates and after entering e.g. EUR 100.- to get it automatically in new cell / row converted in USD 112.-? I have added the example
-
How can I add rows from one sheet to another automatically?
I am trying to create a PO / Invoice tracking system for my team. One sheet has all the blanket PO #'s and amounts and the other has all the invoices that are tied to each PO. So if an invoice is added to the invoice sheet that has a matching PO number to a PO on the PO sheet, the PO amount would decrease by the invoice…
-
Smartsheet Labs - Map
Love the map feature as a quick and easy way to view all of my companies locations and break them down by state or any way we need. I wonder if there would be any way to get county lines include on the maps though.
-
NEWBIE: Smartsheet Feature Relationships
What is the difference and hierarchical relationships between "sheets", "workspaces", "folders", "sights" and "dashboards"? As a marketing director, product / project manager I am just trying to figure out a logical build sequence for my new smartsheet content. Sheets and folders are pretty straightforward, but what is the…