Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Archived 2015 Posts
Archives for July 2015
Discussion List
'If' Formula that Pulls Data from One Cell in Different Sheet
Hi, I have a sheet that shows some data which I want to compile into a new sheet. The source sheet has a coloured (fill) cell and also a note. The formula would be in the new sheet, I want the 'If' to be cell colour or certain text / value (if I must) , the resulting value will be a percent. Has anyone made a reference…
Create time card from project schedules
Is there a template out ther somewhere to take all projects shared to an individual and create a weekly report (timecard) showing the number of hours that indiviual is scheduled to work on each project? It seems like most of this is available in Resource manager but I'd like to have it report hours versus % allocation.
Importing contacts from outlook
Hi, I'm having trouble important contacts from outlook. I have a csv (windows) file saved, but when i import it through smart sheet it tells me there are no outlook (csv) contacts found. I've opened the file. There are contacts listed in there. However, not sure if this is the reason, but the first name, last name and…
Land on the relevant resource's task when redirecting from Resource Views
Hi; It would be very useful to land directly on the relevant assigned person's task when I redirect to a project sheet from the Resource View (via the sheet links located under each resource name). Is there a functionality like this?
Bulk Document Attahcment
Does anyone know of a way to attached documents to a Smartsheet programatically? I have files that are named with a tag that is also unique to a specific row in my sheet (thousands, so manual attachment is out of the question). I would like to be able to periodically attach documents based on this tag as my sheet grows and…
Date/time and year
Im trying to put together a simple Gannt chart for a project in the UK. How can i make a change to the date so it reads day first, then month, then year?
Formula Suggestion: [Column Name]@ to Imply "[Column Name] in This Row"
In Excel 2010, a simple and powerful feature was added to formulas used within tables: the @ prefix. All @Column1 means is this row in Column 1. It greatly simplifies the reading of formulas, and I would wager that accross the entire spectrum of Smartsheet users, most formulas are referring to cells within their own row.…
Set column width?
Hello, is there a way to set the column width to a specific unit?
F4 funtion in excel
Could someone tell me what the equivalent in smartsheet is for the F4 funtion in excel that fixes the cells within a formula?
Question
Has anyone used Smartsheet to track company vehicle miles, gas usage, etc.