-
Sorting recommendations when you have summary rows on the top on your sheet
I am experiencing issues when sorting a sheet and have summary rows at the top. For example, I created summary rows on rows 1 through 10 with formulas and totals, and when sorting, my summary rows get lost in the sorting process. Do you have a workaround to prevent this from happening? Ideally, I would like my summary rows…
-
Setting up Project Management
Hi - I am creating a project management template for events. One of my tasks is sending out emails to customers. We don't send emails on Mondays or Fridays, so if I build out my dependancies, is there a way to exclude Mondays and Fridays only for those rows? I know I can set up parameters for the project but can I set…
-
Resource exports
Hi I'm wanting to use SS more in how we do resource planning. One thing which is quite painful is the output from the export on the resource view. What would be easier as a complimentary tab on the excel export is a more "Pivot table usable" output, for the same range so something like Date Project Resource Allocation this…
-
Can you sync Google Calendar to Smartsheet
Heard that Smartsheet can sync with outlook to send notifications of tasks due and add to Outlook Calendar. Is there a way to sync Smartsheet with Google Calendar?
-
External Resource Allocation
I use Smartsheet for Construction Scheduling and I think it would be amazing to have resource allocation for external parties or equipment. We need to be able to set up a project schedule that can allocate a certain number of workers on a job site to each task and then be able to forecast when a superintendent should be…
-
To set RYG using a formula that considers Todays date and Completion %
I would like to set the risk RYG status column colour based on set conditions. IF % complete = 0 And 'start' is todays date to show Risk IF % complete = between 90 & 100 to show Green somethign like this but it doesn't work =IF(AND([% Complete]row# = "0", [Start]165="TODAY", "Red")) Any ideas?
-
Solution Guides
I just watched the webinar on the multi-sheet Portfolio Management solution. How do I a) find the Solution Guide so I can learn more; and b) lauch an instance of the Solution. As you can tell, I am a completely newbie to Smartsheet. Thanks in advance, charlie
-
Starting Number New Each Month
I use smartsheet as a project management operation for my office. I'm using the auto-number field to create a request number associated with the request, {YYYY}{MM}-0000. I would like the 0000 number to start from 1 each new month. Is there a way to do it other than manually entering in 1 at the end of each month?
-
Number of rows
At the moment Smartsheet supports 5000 rows of information, my excel stands at over 9000. Is there a time frame on when the limit of rows will be extended? Also, my need for rows will only increase so what is likely to be the increase? Without this extension in rows I am not able to use Smartsheet, great shame as it would…
-
Exporting data into a form document
Good afternoon, I've been tasked with exporting data from Smartsheet into a document. The form field ability in Google Docs gives a good format with the fields, but we're needing a way to have several rows of data displayed on one page instead of one page for each row of data. Is there another way to integrate the data in…
