-
Want Dashboard to Update with Data Live Based on Report
Hi - I want a dashboard I have created to update with data live based on the report I have input into the dashboard. Is this possible, by which I mean can a sheet update live based on a report so the metric widget reflects those numbers? If not, what are other solutions, and if a formula is needed can you give me the…
-
How do we get one or more checked check boxes, checked value in one cell? I need to get checked %
-
Will IF(MAX(Collect work?
Hello community, I am using a MAX(Collect( formula to pull in a number from another sheet where I calculate the number of days we have to lock a project's files after completion - this is pulling into our project tracker. The origin sheet is calculating the countdown number based on one particular type of work request and…
-
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…
