-
Countifs - with Hierarchy (Grandchild)
I am trying to write a formula to count the lowest level of "Completed" items. I have multiple Projects and different Status all on the same sheet. =COUNTIFS((CHILDREN[Variable Features/Tasks]:[Variable Features/Tasks]), Status:Status, "Complete", Project:Project, "Test") I'm not working in excel - I just wrote up the…
-
Changing date from Outlook
Hi- I'm trying to set up Smartsheet to track follow up on a large number of small projects. Using the smartsheet for outlook app with the web-based version of outlook (my desktop is 2010), I am not able to update a column with a date from outlook. I am trying to set up a system to alert me if I haven't received an update…
-
Need for darker lines and dates on printed calendars
I export my shipping dates to a sheet that presents the data as a calendar that is printed and posted for our shipping packers and loaders. This is a great tool for allowing those on the team who are not on the computer to plan their workflow. The default color for the calendar grid as well as month and date labels is…
-
Time based totals
We use Smartsheets for project management. We have about 100 projects of short duration that span over several months. We would like to assign staff to each project then be able to see how many staff members are needed during a given week. I picture a number on the Gantt chart bars that show staff on the bar. Somehow a…
-
Reports - Hide Data from Master Sheet
Hello, It is my understanding, that in order to share a report and allow for users to also make edits within the report, that they also have to have visibility of the master sheet that the report is pulling data from. Is it possible to share a report with users, while still allowing them to make edits, without allowing…
-
Does anyone have a grant/program management template to share?
I need a template that will help my team track relatiosnhip management, and grantee relatiosnips- especiallly regarding grant milestone progress.
-
Copying Links of a single cell to multiples on another sheet
Has anyone else had a problem copying a link to one reference cell to multiples on another sheet? We have the problem of trying to link a single reference number on a master sheet to a group of candidates on a second sheet. Functionality-wise I want a change in the master board to immediately update on the secondary list…
-
CEO interruptions causes delays
My CEO continually interjects his own agenda into the company's workflow. It's been a challenge for many years, and we all know that he won't change. So knowing that we, as a company, cannot tell him to stop, I would like to create some visual that will show how his interruptions cause delays in deliverables of other…
-
Weeks/Days Remaining Formula
How can I create a column that displays "x Weeks and x Days remaining" until a task's start date? I know about RYG Balls and what I can do with conditional formatting, but those just aren't sufficient for my needs. In Excel/Sheets I use the MOD function to do this using the following formula: =IF(([Start…
-
Conditional Formatting or Formula
Good Day All: I am trying to use Greater Than Conditional Formatting for two columns. However, Conditional Formatting does not allow you to select 2 columns. Perhaps, I have to use a formula? Here is what I would like to do: If % Complete (Planned) is Greater than % Complete (Actual), then Red If % Complete (Planned) is…