-
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…
-
Date Calculation \ Automated based upon cell value
Good day Everyone: I have a field set up with automated current date, that is used to calcuate\count the # of days of task duration based on current date and task start date. trying to figure out a way to have Actual duration stop counting once the “Sate” of that task.. reflects “Completed”. Or Actual Duration stops…
-
Automate Harvey ball color based on multiple variables
I'm not sure if what I want to do is feasible or not so please let me know if I'm going off the deep end. I would like to have a Harvey ball change color based on several criteria/variables to show likelihood the task will, or won't be, completed on time. Has anyone made a formula that will show a red Harvey ball if the…
-
Multiple reference Formula
Greetings: Trying to create a formula that tracks task duration displayed by "symbol" in conjunction with another condition of the task:... complete, or not started. I was able to get the symbols to show up properly based on calculated duration. However, the bottleneck is related to the formula not picking up a symbol…