-
#Invalid data type in a report
Hi, I want to run a report with the following conditions: Compile report on days overdue column= "#INVALID DATA TYPE" I have inserted rows with days overdue = #INVALID DATY TYPE but it doesn't pull through. Please assist. Y
-
How to prioritize timing in card view
Hi Friends, I have created a project management smart sheet & I asked team members to participate to do simple action in card view by moving from one status to another. And I have planned multiple task with them & mention the status as 'Not Started'. So team members can move the card to 'In progress' column and start…
-
Highlight changes function keep on disabling
Good day, My highligt changes function keeps on disabling. Any recommendations on how to fix this? Thank you, Y
-
Sights formatting and layout issues since the new release
Is anyone else having a problem with layout since the new release. All my Sights that were set up and published are now no longer laid out as they were with widgets all over the place :-( I've spent hours trying to fix and I am finding it extremely difficult to get them to go back as they were. Is anyone else experiencing…
-
Web Forms Best Practices for multiple entries
What is the best practice for a Web form that requires some header information such as Company name, Address, PO#, etc. and then it requires information submitted for multiple products. For example, we need product information for 8 separate products from the same company, and we want to avoid the recipient of the form…
-
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…
