Seeking a smart sheet expert user able to to offer consultancy services. Wishing to use the software as a database to read and report on a number of sheets.
Could someone recommend mac version of Offie Timeline? Since Reporting doesn't support milestones on schedule bars (and make it one bar/row), I wanted to use Office Timeline. The catch is they don't have mac version! Thanks much!
Is it possible to create a report that queries every schedule, even the schedules that I do not have sharing privileges? I thought I could possibly do this through the SysAdmin account, or use the SysAdmin account to add myself to view all schedules. I am trying to create a report that lists all schedule entries labeled…
Let's say my task sheet has dates that tasks are created - not necessary TODAY. And I want to run a report if the created date is this month. For example, Task A's created date is 09/10/2017, and this month is September. The report should pick up Task A if I run report today, but next month. How can I achieve this? I made…
Trying to put a formula that will compute the average rating based on organizational grouping. I have a smartsheet that has a drop down field which includes organization functions like: engineering, IT, Sales, Marketing, ... I have another field that is a numeric rating for these organizational functions. 1 thru 5. I need…
Recently I have noticed that what is displayed in the predecessor column when running a report has changed from showing the specific line dependencies to now just showing the number of predecessors ( i.e., 1 Predecessor, or 2 Predecessors). This isn't really of value when looking at a report. Is there a way to show the…
I am new to Smartsheet I am a big fan of communicating task and project status via a single page. Does anyone have experience of using Smartsheet using the OPPM format?
I'm building a report that will show things that are happening TODAY and in the FUTURE. I can build each of those separately, but together seems to be an issue. I built a filter based upon date being YESTERDAY, but when I go back to check it, it has placed the actual date in the field. Is there a more permanent solution to…