-
Formula / Multiple Sheet Reference Assistance
Hello! I have a summary sheet that references five sheets. I already had to modify my ranges for VLOOKUP on those sheets because I hit that 25,000 cell reference within moments. Three weeks later after changing all of my sheets, I'm ready to proceed to the next step in my project. I have one column that uses a VLOOKUP to…
-
Smartsheet collaboration with Microsoft Teams
Hi, I want to know the accessibility rights of the different types of users (licensed, non-licensed, collaborator...) Example: I want 2 users to be admins so they can add users and create sheets. And I need 20 users to be able to access the sheets, input, and edit information. Also, I need 100 users to be able to view the…
-
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…
-
How to make formulas work on top of a sheet if new entries are coming on the bottom of the sheet via
Hi All I am really stuck with this as I need to amend my fomulas manually every time I have a new entry. Whenever there is a new entry ( via Web-form) I need to change the formula to include the new row instead of helping me with automation it has created extra work for me. Did any of you faced a similar problem? What…
-
automated updating sheet with xls file
Is there any chance to update data on the sheet with new xls without importing it once again ?
-
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…
-
Grid Data Entry - Next Column/Next Row after hitting Enter
I'm entering data into a sheet that has two columns. I would like to be able to enter data in the first column and then hit enter and then have it take me to 2nd column, enter data, hit enter and then have it go to 2nd Row, Column 1. Is Smartsheet capable of supporting this. I can easily do it in Excel by using a 2 Column…
-
Sheet sharing
I was wondering if there is any way to have different sharing scheme for different sheets in one workspace?
-
Filters no longer summarize counts
Before today's update to the new improved Smartsheet, when you used a filter it would give you the count of items it filtered on. Now it does not do this. You have to select all elements in a column to see how many there are. Why did this change? Is there another way to find the total number of filtered elements? This is…
-
Sheet customization
Hello, Smartsheet team: I would like to know if is it possible to customize each sheet with its own logo and colors? Or you can only set a theme in general? Thanks!