or Explore Discussions

# Using Smartsheet

Archives for April 2018

## Discussion List

• Time Tracking
In Using Smartsheet
I'm new to SmartsSheet and don't see an obvious way to track time, and have it recorded against a task Personally not too fond of % complete - to often I've seen people say/think (legit or not) that they're 90% done, and the last 10% take…
11 2
11 views 2 comments Most recent by Linda McGee Using Smartsheet
• Variance Column Showing 1.. Needs to be 0! Help!
In Using Smartsheet
Hi all - I am working on a variance formula to first.. if error make a blank... and then to secondly... calculate the number of working days between to dates. I need the variance of our "planned end" and "actual end" co…
127 5
127 views 5 comments Most recent by Mike Wilday Using Smartsheet
• Percentages are showing minus numbers -120%
In Using Smartsheet
hello all, my percentages are going int minus or over 100% . i currently use this formula , can anyone help    =(TODAY() - [Start Date]5) / ([End Date]5 - [Start Date]5) regards   Carl
16 8
16 views 8 comments Most recent by gabsy1972 Using Smartsheet
• Dynamic Template
In Using Smartsheet
I want to create something that is several columns containing data is is continually updated - but only added to, no content is ever deleted. I'm calling this the "template". I'd like to be able to pull the "template data&qu…
65 1
65 views 1 comment Most recent by Chris McKay Using Smartsheet
• Auto populate risk columns
In Using Smartsheet
Hi All,   I am trying to change the today condition in this formula to today - 2 in order to become red few days before but it's not working.  Does someone know how I could do it? =IF(AND(Finish78 < TODAY(), [% Complete]78 < 1), &…
1 3
1 view 3 comments Most recent by Mike Wilday Using Smartsheet
In Using Smartsheet
I am trying to find a way to use the DONE checkbox to then notify the dependent task assignment that it is ready to launch. I have looked for solutions and come up with the idea of having a handoff column, but then that is just putting th…
11 2
11 views 2 comments Most recent by Andrée Starå Using Smartsheet
• Creation date/time anomaly
In Using Smartsheet
Got a rookie question... I'm using the system-generated creation date/time.  Time zone recorded looks to be correct (EDT).  I have a report that displays the time correctly.  That report is included in a dash board that also looks correct…
1 1
1 view 1 comment Most recent by Mike Wilday Using Smartsheet
• "Dashboards just got better"
In Using Smartsheet
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
15 4
15 views 4 comments Most recent by Tim Using Smartsheet
• wrap text is applied and still not showing all text in my cell
In Using Smartsheet
Can anyone advise. I have typed a paragraph into a cell and applied wrap text but I still only see a quarter of what I typed. thank you.
264 7
264 views 7 comments Most recent by Andrée Starå Using Smartsheet
• Highlight reports
In Using Smartsheet
Is there any enhancements on the way to make the report dashboards more configurable.  Risk Log - highlight report doesn't show the mitigation & when there too much text in a box goes off the page, is there something that can be done?…
25 1
25 views 1 comment Most recent by Shaine Greenwood Using Smartsheet