-
Tracking Time (Tasks)
Greetings, Looking into the prospect of getting my engineers to enter time spent against tasks in addition to 'guessing' and their percentage of completion. It seems the threads here are all a couple years' old or more - wondering if there's any advancements in this arena recently. Regards, jc
-
Using COUNTIF to find the number of Blank Spaces
I'm trying to count how many blank spaces there are in a given column. However, whenever I put in the below formula, it just gives me the total amount of rows in the column, but the entire column is not blank: =COUNTIFS({CDVL Project Tasklist Range 4}, "") I've also tried this formula, but to the same results:…
-
Creating a Link in Dashboard from local drive
I have previously been able to create a link to a local drive document on a dashboard but now don't seem to have the choice. Can someone point me in the right direction please? I have the options of Google Drive; OneDrive; Box; Dropbox; Evernote; Egnyte Thanks
-
COUNTIFS to count when a cell contains any version of a word I want to count
How do I indicate that I would like to count any time the cell has "DESIGN" in it whether the cell says exactly "DESIGN" or "re-DESIGN"?
-
Automatically Sort Data
Hi, Our team works with a spreadsheet which currently is updated quite often / simultaneously by several users. We have been facing difficulties whenever new information is added, since sorting is not properly adjusted until we manually select sorting, refresh and save the data. Is there a way to automatically sort…
-
How to print without Conditional Formatting?
I have a sheet with a lot of conditional formatting that must be printed in the gantt view without any of the formatting. So each week I have to disable all the rules, print, and then enable them again. It's tedious. There must be a better way. Any thoughts on how I can generate a gantt in a PDF without the rules and…
-
How export to Microsoft Project without dates missmatch?
When export my Project to Microsoft Project, start and due dates doesnt Match with smartsheet dates. Some one know that do I need yo do to hace the same information?
-
Need a Column Property type that is "clock" or "time of day"
As an event management company, we have on-site event schedules that require a "start" and "end" time column. Those columns need to reflect the time of day and currently we have to create a whole drop down list of 24 hours to choose from for those columns. Am I missing it if it already exists? Or, if not, it would be great…
-
Label Parent to Sub Tasks in Reports & Reminders
It would be helpful if Reports, Reminders and the current Outlook Beta displayed parent task descriptions when information is displayed for sub tasks. In our organization, many sub tasks could have similar descriptions in several phases of our projects. It would be beneifical to see the parent or outdented rows description…
-
Wanting to count dates within a column
Hello, I'm trying to create a monthly report from quarterly data. I want a formula that will count how many projects went live in a given month from a column of dates. In the screen shot, I want to put a formula in the blue cell that tallies the Actual Live Date column. Thoughts? Thanks! Shannon