-
Help wanted
We re looking for a subcontractor to assist in design and implementation of construction scheduling, task management, and resource allocation for a small construction company. Presently, working with Microsoft Project and need to revamp our solution with Smartsheet to be more detailed, efficient, and useable.
-
Auto-Number Fields on Form Creation
Hi Is there a way of Auto-numbering Fields during a Form creation? Put simply can you automatically number questions 1, 2, 3 etc? Or can this only really be done manually by changing the column titles? i.e. 1 - Where do you live? (for example) Many thanks Nick
-
An error has occurred in the application. Please log out and log back into the application before c
Hi There We have call Smart sheet a number of time, left about 5 messages and still waiting on a reply I have also emailed as seen below. Regards Jacqueline Niemand Hi there, We Emailed over 10 hours ago and it’s still coming up with the following error we have loss a whole day with a number of staff not being able to done…
-
Column Copying
Hi, I have a need to add columns to all of my active project Smartsheets and then I need to create a webform on each of these sheets. Based on other posts I've seen, I cannot copy these columns from one Smartsheet to another so I need to manually add them, correct? Also, there is no way I can copy a webform from one sheet…
-
Assistance rolling up data to a master sheet
Hello, I’m trying to create a roll up for multiple resources across multiple sheets. I would like to have data roll up like how it looks in the Resource Allocation, but I’d like to view allocations in hours rather than percentages. I've attached an example of a project schedule in SmartSheet that we use. I thought that it…
-
Date Created System Column not updating if NOT using webform
I am modifying the "Help Desk Ticket Tracker & Form" template. I don't want to double-enter the date, so I deleted the 'date' column and am using the 'Created (date)' system-generated column. When I use the webform, it will fill in the date created. But if I add a line directly in the smartsheet, it leaves the Created date…
-
Emailing reports, except for when blank
I have a report pulling data from several sheets inside my workspace. Essentially it emails the report as an attachment every morning at 9am to my team and lists out open project needs. The question is there are some days when the report is blank (ie. no open project needs). Is it possible to: * not send an email if report…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
Help with Column Edit Permissions
Hi All, When I share a sheet with my associate (or visa versa), the person who did not create the sheet is not able to edit the column properties. They are 'grayed' out. I checked and it looks like we both have the same permissions, so Im not sure why that happens. Any advice would be appreciated! Thanks, Robyn
-
Help with date formula
Need formula to calculate a date: Spreadsheet has (3) Columns as follows: Cal Type (drop down) with 2 options - In-house or Third-Party Next Cal Date: Date Reminder Date: Date Would like formula to calculate the following If/then scenario: If value in Cal Type is "Third Party" then need Reminder Date to be Next Cal Date -…
