-
Time Tracking integration with TimeCamp
Hi all, It was recommended a while ago that we use integration with TimeCamp to track our time because SmartSheet does not have that capability (and boy do we wish it did!). TimeCamp seems to be able to synchronize with SmartSheet and pulls all the tasks for a project if the are in the primary column. Our employees track…
-
Project Time Tracking
Good morning, Does Smartsheet have, or plan to add, a timer feature for deliverables? Currently our project leads track their time manually or use programs such as the Outlook journal. I would like a feature in Smartsheet where a user can start a timer on a row and the duration would update each time a user starts and…
-
Mark child if Parent meets criteria
Hi- I see lots of threads to mark a parent if a child meets a certain criteria, but I am looking for the opposite. I have Material, Labor, and Subcontractor Parent rows and would like to mark the children with either a number or letter indicating if it is a child of one of those parents (Material =1, Labor =2,…
-
Modified Date and Conditional Formatting/Alerts
I have hit a problem that Smartsheet can't seem to deal with. My goal is to create a sheet that runs conditional formatting based on the differential between 'Modified date' and a TODAY equation. Firstly I tried to create a TODAY based formula in the conditional formatting tool. However, this acted as a figure once…
-
using Harvey ball status to drive a formula
Hi, Is there a way to use the harvey ball status to drive a formula? Here's an example of what I was able to achieve in excel but cannot replicate in Smart Sheet. =If(HarveyBall = "Full",date-today(),"") Result in excel, I get blank if result is true Result in SmartSheet, I get #Unparseable Observation is that the…
-
Add a New Task with all the sub rows
I have a sheet where I have all my projects and then sub categories indented underneath it. Is there a way I can easily add a new project that will create automatically add the sub categories?
-
Constructing URLs to particular rows in sheets
Hello, I am collaborating in a project and most of the work being conducted is external to SmartSheets, which is being used as a planning tool. I would like the ability to construct an URL / Hyperlink that references particular tasks / rows. The idea is that as the project SmartSheet gets extremely big and with multiple…
-
Having a form as an email
I am trying to have a form go into smartsheet once it is completed with the same colors and as the form and also not show that things were updated in yellow. Is there a way to do this?
-
Title characters
Is there a way to increase the character restriction in the column titles? I need this for the forms I am creating, they need to be longer in the column title to create the forms I need.
-
Lookup reference in another row referenced
Hello, Possibly this cannot be done in Smartsheet. I am trying to port over our drawing list coordination sheet from excel to Smartsheet. The formula uses Lookup in Excel - actual revision number to find on the same row that number - then return the date of that column from the first row of the sheet. The excel formula is…
