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 2016 Posts
Archives for March 2016
Discussion List
Rows Disappearing after having been moved from the origination page.
We have our sheet set up to where 1 sheet is used for order origination; the row is then moved to the sheet of the person who will be completing the task. The person will see it on their sheet and is able to change the status to accepted; however, in time, the row disappears all together. This is causing a lot of issues…
Hours Calculation
Is there any way to calculate the difference between two differente times, like: Column 01 ==> StartTime: 11:00 Column 02 ==> EndTime: 12:45 Column 03 ==> Hours: 1,75 Thank you
Prevent deletion of rows if it contains locked cells?
We are trying Smartsheets for a project and are running into a major issue. The sheet contains checkboxes of things to do, along with dates, and who did the particular task. It is crucial that the 'Task' and 'Date' columns be protected. Unfortunately, we're finidng that if you are an editor, even though these two columns…
Count checkmarks
I am looking to count the "checked" boxes of subtasks and then also have a total of all of them. What formula approach should I use. I have tried this "=COUNTIF([Bid Recieved]29:[Bid Recieved]35, 1)" which I believe is right out of the refernce page but does not work so I tried this "=COUNTIF([Bid Recieved]29:[Bid…
% Complete, Duration columns
Can I create % Complete and Duration columns in a sheet created from the New Blank template that does not already have them?
Resource location dependency
Hi, Is it possible to constrain resources based on location? Maybe have a dependency or something that would allow me to schedule only North East resources on projects located in the North East. If none are available, I'd be able to override this dependancy as well. Thanks!
Column name/header
Feature request It would be great if I was able to format my column name/header. Specifically to wrap text so I can see the entire label for narrow columns.
Update Feature
Can you request an update just for a column?
Feature Request-Bullets in Cells
I am sure this has come up before, but I couldn't find it in a search for bullets. I am trying to use Smartsheet for proposals and it would be so helpful to be able to format a long list of items with bullets. I realize I can create them with bullets in a text editor and paste them in, but it would be much easier to work…
WEBFORM
Is there a way to limit the number of registrants using a WEBFORM?