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.
Discussion List
Date Counter for Weekly Ontime Rate
Hi there! I need some help coming up with two formulas that will count how many times in the week we hit our projected due date and how many times we are early. I already have a hidden column that looks at the date and calculates the week of the year. I need the fomulas to read something like: count if 'date completed' is…
multiple signatures of unknown individuals on one document
I am creating a training tracking Smartsheet for our field employees. My challenge is coming up with a way to add signature lines (and text box) for all employees on-site for training to verify with signature that they have attended. I don't know beforehand who will be on-site for the training and the employees are union…
Uploading a photo for the community
This is a very silly question. However, I have tried to upload a my photo to my profile. But, nothing happens and no photo is displayed. I know it warns that it needs to be smaller than 1024x1024 pixels and I have made it smaller than that. What is the trick to this? I thought about sharing a formaula technigue that I…
Training Record
* Hi * I am wanting to create a sheet to keep track of our employee traing records. We have approximately 20 employees all with a number of training qualifications which they need to re-sit at diiferent intervals. I need to be able to list the employees with rows or columns for their qualifications where we can enter the…
How do I provide a colleague rights to edit a webform?
Have given him admin rights to the sheet & workspace, but he still can't edit the webform. Thoughts?
Feature Request: vCard in Contact List column
Since Smartsheet's collaboration leverages email, It would be nice if the Contact List column accepted vCard / *.vcf files (surprised to see the "Email" was not on the Functionality list for the discussion topic. Craig
Two Smartsheets- linked- add row in one- can it auto add linked in 2nd?
Hi, I"m working with two smartsheets for test planning.... The primary sheet goes over the what is being tested, which teams, the planned volume & dates. The second sheet is for results reporting and links back to some key fields in the primary sheet. Problem I have- if i add data to the primary (ie new test event)- is…
Formula that only counts business days
Hello, I'm trying to write a formula for a date that will say something like "due in 18 business days". So basically " =[column name] + 18" but exclude weedend days. Is that possible? Thanks so much!
Real time & ressource management
Smartsheet is a great product with great features, but it lack in crucial features for any real event and logistic planning. Add time/duration management for task When selecting a start and end date for a task, we should be able to select a time for it as well. We cannot be limited to fixed hours work day or using "gaps"…
IF statement with two criteria; not functioning
Hey all, Trying to get a “No” to appear if the checkboxes in each column haven’t been checked off by their due date. Currently, it says no regardless of the date and it only seems to switch to "Yes" if the Client Launched column is checked off. The two criteria are that the box is not checked off and the Launch Date is…
