-
Faulty Microsoft Project import
All my projects start with with schedules developed in Microsoft Project, either internally or by contractors. One I have a draft or baseline in MS Project,ย I would like to import it and mange my changes and updates in Smartsheet. Unfortunately, I am finding the import from MS Project into Smartsheet very unreliable. Evenโฆ
-
How to calculate effort relative to working hours?
As a new user I'm working my way through the Smartsheet product. Thanks to the 'best answer' in this post I was able to calculate the Effort (or Energy), which is visualized by 1 to 5 people-icons; this way Duration can be set or calculated for regular project planning, but in Card View this is automatically shown by anโฆ
-
Is there an easier way to request backups?
I create several projects a week, and I would like to stream line the backup request process. Instead of right clicking on each project worksheet and selecting both Request Backup and Schedule Recurring Backup, is there a way to do this for several projects at once? Or better yet, when I "Save as new" a project, can itโฆ
-
Need suggestion for duplicates
I have a sheet that allows deliveries to be entered. They have a date, location, start time and end time. I have restricted the times to whole hrs 5AM to 10PM. I would like to know if some enters a delivery at the same place on the same date with a time that overlaps another. Any suggestions on how this might beโฆ
-
Report is pulling correct results, but cells are blank
I have a set of project sheets that all share the same basic layout and format, AND also have all the same sharing permissions -- specifically, I am the owner of all of them. I'm trying to generate a report that shows me all sheets with an End Date in the future for a specific task / row in the sheet. The report seems toโฆ
-
Row & Update Requests - see message comment?
I have a sheet set up to track drafting requests. i.e. A staff member submits a request to create or update a site map. The persons in our drafting department get notified and one of them will start on the task. In trying to keep all communications within SS (and not email discussions), I've instructed the draftingโฆ
-
Email Address of a Sheet
I might be mixing up this functionality with a different product but I thought Smartsheet had the capability to email a sheet and the information in that Email automatically gets added as a row to that sheet. I can't find information on it in the help documentation but I thought I remembered seeing this referencedโฆ
-
Prevent Check Box formula from erasing when check-box is manually checked by accident.
In below scenario, check box formula disappears when the cell is checked manually by accident. Is there a way to prevent check-box-formula from being erased when the check box is manually checked? โข Pls refer to attached picture โQuery - Check Box Formulaโ for check box formula used. Thank you. Jon
-
Automatically check-mark parent row when all children rows have been check-mark
In below scenrio, is there a formula or some approach that will enable new added rows to be automatically accounted by formulations on outdent rows? The purpose is to automatically checkmark the parent/outdent rows when all their children/indent rows have been checkmarked. Pls refer to attached picture โQuery - Checkmarkโฆ
-
Sending auto update request based on % completion
Hi, I want to send update request automatically to shared users of that particular sheet after the % completion column is 100%. Please guide me, how it is possible. Thanks.