-
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ā¦
-
Creating dependancies so I can change my start date
I am setting up a project plan but at this time I am not sure what my start date is. I can set it up with a possible date and create my tasks and dependnacies. But how can I make sure my dependancies are set up correct so that when I change my start date everything will fall into place.
-
Flagging Red using two conditions
Desperately trying to find a formula that does this:Ā if due date is past and checkbox is blank then flag red in Symbol column For Row 15, tried this but it is not parseable. I used this formula in the Flag column =IF(AND([Checkbox]15 < 1,TODAY()>[Finish]15)1) says UNParseble
-
How to collect comments from individual sheets, cell-link to a master sheet (eventually Sights)
Hello everyone, For my dashboard (Sights), I show status updatesĀ from individual projects. There are multiple updates columns per project I have to pick up. For now, I addedĀ extra rows on top of project, and people fill in updates there. Then I cell-link those columns to a master sheet (and create a report for dashboard).ā¦
-
excel doesn't recognize text/number column from smartsheet
I've linked an Excel worksheet to a Smartsheet report it works fine but one column that has a numbers and text (p.i. 4551A) is imported blank (no data). When is a regular number imports it just fine. Does anybody have any idea what could be the problem? Thanks, Herb
-
Parent row based on children status and due date formula
Hello, I have a sheet that tracks event deliverables for 150 or so events each year. The way the sheet is set up each parent row is the event name, and then the children rows are each task for that event. I have a column for Status with the options for Complete, Not Started, and In Progress. I want to create a new columnā¦
-
Timestamp for changes in each row
Hello, I created a "Modified" column in smartsheet to track changes for each change within that row. It appears to be constantly changing in the entire COLUMN whenever any thing is changed in the sheet. This is a major problem since my formulas are referring to the cell that has the last change mod done to it. Is there aā¦
-
how open a link from a Hyperlink cell
Dear all I've crated some hyperlink to local directories, I'd like to be able to open link when I clic on them (Only cell edition is available, to change the value) Thx
-
Regular Expressions (RegEx) with FIND function
Hi Team, I'm guessing that SmartSheet doesn't support regex in formulas as I get an #UNPARSEABLE error when I try it but I thought I'd better post the question here before I make that assumption. I have the following text in my "Subject" column: [1751] - Guide Posts With the formula: =MID(Subject1, FIND("[", Subject1) + 1,ā¦
-
Labels for RYG Balls
Hello I am sure it is an easy answer, but, I cant seem to find information. Is there a way of having a label associated with one of the RYG balls, ie when the green ball is selected, the next column says 'Active', The red ball would be 'On Hold' etc.