-
Reports pulling data from a sheet
I there somewhere you can look to see who has a report pulling data from a sheet? I recently made a column type change in a sheet and this impacts a report if the column is selected. I know the Activity report within a sheet shows some items but not if the sheet is being used in a Report. Thanks, Peggy
-
Individual task lists for unlicensed users
Hello, can an unlicensed user see a list of all tasks assigned to them (across different sheets)? Our resources are frequently unlicensed as they only have to view the tasks, so they can't create reports. I guess the project managers could create reports for individual resources, but the problem is that not all departments…
-
How to count grandchildren.
I'm trying to count how many grandchildren I have in a chart, how do I create the formulas for this? Note that I would be adding and removing rows and I need this counter to keep updating with rows inserted and removed. Example: * Parent (Grandchildren Count of 6)* Children (3)* Grandchildren * Grandchildren *…
-
Forms
Is there any way at this time to add a photo into the title area of a form? IE on the one beneath where it says, "SmartSheet Popping Plate" Would there be any way to put a photo there of say a company logo?
-
Calculating Avg WD with Stipulations
I'm trying to calculate the average amount of workdays it takes for someone to respond using "Date Forwarded to DPD Command #1" to "Date request is returned from DPD Command #1" while having the "Command #1" column holding that specific command. I've played with it for a while, and can't seem to get it right. I currently…
-
Formulas For System Column
My sheet has a system column that shows the Modified Date of each row. Is there a way for me to pull the most recent date out to the sheet summary? I tried =MAX(Modified:Modified) but it says that it is an invalid column value.
-
Stacked Area Chart?
Hello, I would like to report the issues on my projects using a stacked area chart as per attached screenshot. Is there any way I can do this in Smartsheet? I am mainly talking about Dashboard functionality. Thank you!
-
Are Kanban and Resource View compatible tools?
We use many (60 or so) individual sheets for each project and a single "dashboard" sheet that aggregates info from all other sheets. We would like to use both the Kanban and Resource view but keep running into this problem: Kanban works on a single sheet (not multiple sheets), but Resource View is only useful when used on…
-
Unable to use a simple formula in the "Assigned To" (Contact) column
I have a project schedule that looks something like this: Row | Task | Assigned To 1 | Task1 | Name1 2 | Task2 | Name2 3 | Task3 | Name3 4 | Task4 | Name1 5 | Task5 | Name1 6 | Task6 | Name2 Once I assign Task1 to Name1 in Row 1, I want Task4, Task5 to change to whatever Name1 is. So I use the formula =[Assigned to]1 in…
-
Every 2 Weeks Alert Not Working
I set up an alert that says send an alert every 2 weeks starting on Monday, Nov 4 @ 9 a.m., the condition is the status must be 'Open." However, it doesn't send. If I sent it to weekly, hourly, daily, it works but the every 2 weeks won't send. What am I doing wrong?