-
Harvest (time tracking app) +Smartsheet integration
My organization uses Harvest for time and expense tracking. So i was excited to see that there was integration with Smartsheet in which i manage my portfolio. However currently it seems as if the integration only works as an export in one direction from Smartsheet to Harvest. Are there any plans to make this…
-
Duration calculation issue
I don't know if it is bug or feature, but it looks strange for me. So I have sheet created based on project template. I have dependency turned on. I noticed next behaviour: If task start at weekend or holiday then duration calculated with one extra day. On attached image all tasks (except task2) have wrong value in…
-
Scheduled email based on a condition - Request
First off, having scheduled email across the entire platform would be a godsend on its own. Such as from a report. This way i can have only the information i want them to see is sent. Secondly, sending an email based on a condition. Basic example, if a box is check, send the email at such dy and time. Is there a better or…
-
Calculating date due for Service Level Agreement
I have a date assigned column which would be the date someone entered a case. I'd like to automatically calculate in a due date column the 5 day SLA date, accounting for weekend days. Is there an easy formula for this?
-
Tracking New Smartsheets - How to request and track the sheets
Has anyone worked on a SS template for users to request/update new Smartsheets? I could use a standard ITSM ticket tracking system, but I'm leaning toward a webform users fill out to request a new Smartsheet. I could use the functionality of SS to communicate updates, gather requirements, and discuss other SS request…
-
i am trying to set up an It Service Request Tracker - Need workflow approval
Ii am trying to set up an It Service Request Tracker that can incorporate the request being sent to specififc individuals for approval. In other words before a lower level user can submit a request, Mgmt needs to review and approve it. Can that be done?
-
Indenting in Wrong Column (maybe because of Frozen Columns)
I froze the column "company name" so that it and all the columns before it would follow me across the spreadsheet as I entered data. I am now wanting to indent rows below a couple new headers: "Commitments" and "Prospective" but as you can see in the screen shot below, the "-" symbol keeps showing up in the column just…
-
Conditional Formatting - Filter odd/even numbers
Is there a way to filter and do conditional formatting for odd/even numbers used from auto-number? If not, I would like to pose this as an enhancement request.
-
Date Formula in a Gantt Chart Cell
I have tried to add formulas in the start date column for a gantt chart that reference a base start date cell and add a certain number of days to the start date. Is that possible? Example of the formula I am implimenting: = StarteDate + 10 The gantt chart start and end date columns use the Date/Time type of cell and Date…
-
help - with formula/cell linking across multiple sheets automatically, without having to manually ad
Summary: I have loads of sheets in a "project" folder, 1 for each project, which have identical layout (column names etc). Each sheets has a region field, which is either UK, China, Japan, HK or Multi. I then have reports which take the relevant information I need from all sheets in the "report" folder, which is then…
