-
Creating different sheets based on one main sheet.
Hi everybody, I need to create separate sheets containing different information from one master sheet. But I also need to configure this in a way that if a new row is added to the master sheet, it will automatically be added in all other sheets that I created based on the master sheet. Any help is appreciated!
-
Editor Moving Rows on a Sheet
I ran into a concern today with Smart Sheet. In an attempt to copy rows from someone else's sheet (on which I am an editor) to my task list so I could keep track of items assigned to me, I accidentally selected move. Unfortunately, once I did, it moved the rows and would not let me move them back. I was able to copy and…
-
What happens to Workspace items, if existing owner is not with the company?
Hi, I have a quick question; although I do know about the System Admin capability that allows it to transfer the ownership of items to a new user via User Management option. But does it also transfer items which that user owned in a Workspace (not workspace but the items on it!)? If yes, then I am good :) If no, then what…
-
Can I drill into a dependency in card view?
I have setup card view and can show the row number of the dependency but unable to view the details or title from the card view. Is there a way to view without having to switch back to card view?
-
Baseline in Gantt chart
Hello, I was wondering if a visual solution to show baseline dates vs. actual dates on gantt charts is already available. Thanks
-
Widget when Pulling Reports
Hello, I would like to have multiple reports(because of the different people assigned to different projects) on my Dashboard but I only need certain columns from each report. How can I make this possible. Thanks!
-
SUMIF formula for adding up in a date range
I have a sheet that I am using to collect a list of items weights and have multiple per day. i want to capture all the weights that are today and for the next 5 days and sum them up if possible. Currently i have tried this formula =SUMIF(Date:Date, <=TODAY(), [Qty (ton)]:[Qty (ton)]) but this includes all the past dates,…
-
2FA for Small Businesses
Hi I note that 2FA is only available for Enterprise plans. In today's world of Information Security, small businesses (mine included) use 2FA for everything where possible. Please may we have this for small business users? We want to protect our data and this provides the extra facility to do so. Thanks Purnima
-
Creating a Chart from Non-Numerical Data for a Dashboard
I would like to have a pie chart on my dashboard that displays percentage of types of activity from a column in a sheet. More specifically, I have a column in an IT tracking sheet that has a dropdown menu. I would like to be able to display on a dashboard the percentage of each activity in the sheet. (e.g., a pie chart…
-
Relational Database Capabilities
I am looking at relating multiple tables of data together for both data presentation/data entry and reporting purposes. I have the following tables: implementation projects (high level project info like scope, start date, end date, project indicators, etc.), customers, customer contacts, development requests (SCRs), etc.…
