-
BUG: Update Request tab shows incorrect value
I created a single Update Request to three different users. One of the users updated the UR. When I went into the sheet, the tab still showed Update Requests (3) until I opened the dialog at which time, the number changed correctly to (2) I think this is reproducible. Any one else seeing this? Craig
-
Resource Allocation
I would like to create a Team in Smartsheet that is identified as a Resource. Is it possible to create a Resource without assigning an email to the resource?
-
Multiple Order Tracker
What's the best template to track multiple orders from multiple people. We've tried uploading PDFs to rows but can't capture totals of each product. Drop down menus could work, but no way to add in quantities. Please help!
-
Conditional reminder
What is the formula that will send me a reminder if a task due date is in the past and the progress ball is red? I have my team track task progress with the RYG balls. If a task has a due date and it hasn't been completed by that due date (as stated by the red RYG ball) I would like to receive an email or alert telling me…
-
Average formula for cell values calculated from another formula
I'm using the SS Jira connector for Jira and have create a template for my team to use. As part of this template I want to calculate the % completed field based on the task's status (the built in % complete of the gantt project only work at the parent level after manually inputing a value for the child task). I've been…
-
Publishing SmartSheet schedule to Shared Exchange Calendar
I want to connect a SmartSheet project calendar to an existing shared Exchange calendar that is available to everyone in our organization. The goal is to maintain a project schedule in SmartSheet (with all of its great features and viewing options) but make it readily available as a shared calendar to Outlook users so they…
-
Change drop down cell to Complete if %=1, If not leave drop down cell at currnet value.
We have Project State pulldown column that consist of Active Complete Future Parked. We also have a %Complete Column. Is there a way to set the Project State to Complete when the % = 1(100%) and leave it at the current value if the % <> 1? If there is a better method or sheet setup I am all ears. Thanks!
-
Pasting into an Auto-number does not auto-number in sequence
Hi all, I just pasted a list of about 20 records into a autonumbered sheet, The auto numbers did not appear in sequence. The paste is as per the original sequence, the autonumber field, jumps around with out rhyme or reason? e.g the fields sequence 179, 180, 181, 184, 185, 189, 190, 191, 192, 194, 195, 197, 200, 188, 193,…
-
Single update request to multiple people failing?
Anyone else seeing this? A customer reports that when she send a single UR to multiple people, the first person "wins" and the others are locked out. I have not been able to reproduce it. Previous behavior: 1. Send UR to multiple people. 2. Each gets email. 3. Each tracked separately The customer says it does not work that…
-
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
