-
Build report off activity log data from a Sheet
I know that I can download an activity log from a Sheet, but is there an easy way to build a report off the activity log data? I want to track metrics like # of sheet views, unique users using the sheet, usernames in the sheet, etc
-
Lock Specific Cells
Currently the only option we have is to lock the entire row. Sometimes, I want people to change a value and have that change other cells and lock the values in after a submittal or an update without locking them out of the main cell they need to change. If this is implemented I would also like to see this option appear for…
-
Merged: When Copying or Moving Rows, Let us Choose Which Columns to Move Don't Just Default to All …
This discussion has been merged.
-
Is there a way to format numbers from decimal into fraction like excel does.
I am in construction and the need for fractional formatting is very important. I have seen other community questions from 2017 regarding this but has not been updated. Will there be an option for the formatting soon?
-
Past Due Date in Business Day Formula
Hi! I have a formula I have been trying to figure out. I'm getting stuck because I want to make sure that the duration does not include weekends or holidays (if possible) and there is a condition. Any help would be appreciated. I would like to know how many business days past due a project is from today, but only if…
-
Auto Populate Contact List on Shared Smartsheet
Hello- I am looking for a solution to populate a couple hundred contacts into a Contact List for a shared Smartsheet without adding each contact to the sheet's Contact List manually. Here is the context: I have a shared Smartsheet that my team uses for tracking projects. Each project is assigned to a member of my team (all…
-
API for linking MS Excel to SMARTSHEET
Greetings I am handling a number of projects and making Gantt charts to track their progress. The data for these charts are stored in MS Excel sheets on my local drive. It becomes cumbersome to manually import the dates and numbers to update the Gantt chart. I want to know, if there is way I can circumvent this problem. I…
-
Sheet Structured drop down list
I am looking for a solution to create a drop-down list with 125 options, which can be structured using categories to help users navigate and find the right option. Ideally, I would like to implement a filter at the top of the drop-down list, similar to the filtering options in Excel, where users can click on a category to…
-
locking row to the top
I have a sheet that gets filled with data from a form, is there a way I can lock the top row so when the form is filled the new row appears below the top row. I have the row locked but new rows from the form always appear above it. Just having the row appear at the bottom wont work for me as I want formulas in the top…
-
Freeze Column issue
Good afternoon, We have a Freeze set to maintain the view of a certain columns that are referred to throughout the day. However, the freeze doesn't actually work as expected, as almost every time I go into our sheet the pane has been moved either direction which defeats the purpose of keeping certain columns visible at all…
