-
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
-
Merged: Lock Specific Cells
This discussion has been merged.
-
Maximum number of cross-sheet references per sheet
Dear Smartsheet, Please tell me that the below error is just a soft cap like the 5,000 cell-link limit. I probably have 100 unique cross-sheet references in a metadata sheet I've been putting together. I am about 90% of the way through and just encountered the below. The way my sheet has been structured makes it impossible…
-
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?
-
Merged: When Copying or Moving Rows, Let us Choose Which Columns to Move Don't Just Default to All …
This discussion has been merged.
-
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…