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 2017 Posts
Archives for April 2017
Discussion List
Reporting over and under allocation?
Hi! Is there a way to create reports showing over (and under) allocation for assigned individuals? In resource views you can see the over allocations on a day by day basis, but I'd like to filter out only the over allocations and present it separetely since that is where actions needs to be taken. I looked for the "alert"…
Counting RYG Balls
Hi guys, Is it possible to count the number of balls according to their respective colors? Many thanks in Advance.
Limit Number of Sheets a user can create
Hi, I am a system admin of our team plan and we are giving our employees a user account. However, due to the limited number of sheets bundled to our plan, we'd like to control the number of sheets, each user can create. Is there a way we can limit the number of sheets each user can create? Thanks, Francis
Tracking equipment assignment schedules
Another dept is looking at specialized software to track Evaluation units we have in the field. Then someone said "maybe SmartSheet can do that". Here's the picture: 1. We have equipment, identified by SKU and serial number. 2. We have organizations using this equipment. 3. We want to track where a piece of equipment is at…
Number and Fraction Format
We currently use a considerable number of sheets that need numbers to read as fractions. (Construction/Exhibit Industry for dimensions) Unfortunately, if you type out a number as a fraction it cannot be used in formula. Excel can translate easily between decimal and fractional display with cell formatting. Will there be a…
Display predecessor task NAME
We would like to write logic to display all predecessor task NAMES in a new column. So we want the predecessor task ID to be in its usual column, and we want a NEW column that shows the NAMES of the predecessor tasks. Anyone done anything like that? Thanks Robin
Current work filter for tasks not Complete and Due in the next 2 days or the past
I am trying to build a filter that will be utilized to Identify Current and Past due work. I can get the filter to find all not Completed or Canceled work in the Past or the Next # of days. I cannot get it to find all taskx from 2 days in the future and older. Is there a way to add a formula when using is less than or…
Update Requests
Hi, We have set up update requests today to Deliver: Once on 17/04/17 ar 00:00. This however sent through immediatley? Other lines in the same sheet have exactly the same update requests set up? Is this an error, or am I doing something really silly? Many Thanks
Filter sharing option not available
I am owner and creator of a sheet in which my filter sharing check box does not show up on the create filter box. My plan allows filter sharing. Do you know why this is?
When a Web form entry adds a new row to a existing sheet how can you set up that the columns are in
Hello hop I can get some help we have a sheet we track expenses of field projects that has a basic Sum fuction to add of total cost then links out to a nother sheet for tracking the budject vs actual if I use a web form it creates a new row my question how do I get that new row to be adumaticly add the the colom sum…
