-
Time Tracking
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% takes as long as the first 90% (or, unfortunately, more) People often think they're almost…
-
Variance Column Showing 1.. Needs to be 0! Help!
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" columns. I have the formula just about right! But it is producing a 1 instead of zero when the dates match.…
-
Percentages are showing minus numbers -120%
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
-
Dynamic Template
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" exactly as it is - format, parent/children, text, etc AND as it changes into other sheets so that…
-
Auto populate risk columns
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), "Red", IF([% Complete]78 = 0, "Blue", IF([% Complete]78 < 1, "Yellow", IF([% Complete]78 = 1,…
-
Automate Notification
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 the same information twice in the sheet. What I am wondering is if there is a way to…
-
Creation date/time anomaly
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. I "published" the dashboard and accessed it from a provided link. The time displayed is…
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
wrap text is applied and still not showing all text in my cell
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.
-
Highlight reports
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? is it possible to adjust the text character limit also?