-
Sum of a Cell Range, Dependent on a Dropdown Value
Is there a way to add up the total of a cell, dependent on the drop down value of the row? For instance... I would like to total the sum of the revnue (shown in the "Live Revenue Log") by the day (shown in the "Daily Revenue Overview")
-
Show dates beyond 90 days
We need to report on Jobs that has not been touched in the last 90 days. When we start a new Job we copy 4 "template" rows which include dates in the future. When I run my current report, it looks for dates on the parent row, but this row is showing the oldest date for the children. If a job has not been touched for over…
-
Multiple selections from drop-down list, enhance database function
I saw this in a thread from 2015 but wanted to re-start it. Would love the option of being able to select multiple items from a drop-down list. This is handy for improving the database functionality. Many times I have sheets with dozens of projects/rows, and I need to list multiple values for a single attribute, then query…
-
Free Collaborator / Unlicensed User
Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row. secondly: if Unlicensed User delete row or related information in row how the admin will get to know what happend or what is…
-
Exclude sheets from reports based on sheet name?
Is there a way to automatically exclude sheets from reports if the sheet name contains a certain string?
-
Export to MS Project (XML) - Greyed out
The function - Export to MS Project (XML) - is no longer working Has it been taken out of my subscription and have to upgrade or someting?
-
Calculating the Number of Tickets Opened
Hi There, I am currently building a Dashboard and I want to show the number of Tickets that have been opened for a certain period, e.g. the number of tickets opened with a week. Is there a formula that I can use to achieve this.
-
Filtering/Slicing in Dashbaords
Hello SmartSheets Team, I am a little new to SmartSheets, but I have successfully built a dashboard with all the data I would like. However, I can't seem to find any functionality that allows me to filter/slice the data in the dashboard view, say to specific users or anything like that (for example, I can see total sales…
-
How to link a column to another sheet so I can run a formula on duplicate values?
Is there a way to link a whole column to another sheet? I need a whole column linked, not just cells. Copy and pasting 500 cells at a time is not going to work, as it will not update if rows are added or deleted. I considered a report, however that would only accomplish part of the job, as I want to filter the results. I…
-
Single or multiple project Status Widget
Hi, I would like to see a progress report as shown in the attached image of individual project sheets or across many project sheets. Functionality would include clicking the numbers to see the rows and take action on them.
